1. List the city, state, and zip codes in the customer table. Your output should not have duplicates.

2. List the name, department, phone number, and email address of employees with a phone number beginning with "5-".

3. List all columns of the resource table with a rate between $10 and $20. Sort the result by rate.

4. List the event requests with a status of "Approved" or "Denied" and an authorized date in July 2005. Include the event number, authorization date, and status in the output. (Hint: Surround a date constant with pound symbols (#))

5. List the location number and name of locations that are part of the "Football stadium". Your query must not use the facility number ("F100") of the football stadium. Pretend that the user knows only the facility name, not the facility number.

6. For each event plan, list the plan number, count of the event plan lines, and sum of the number of resources assigned. For example, plan number "P100" has 4lines and 7 resources assigned. You only need to consider event plans that have at least one line. 5

7. For event requests, list the event number, event date (event request. date held), and count of the event plans. Only include event requests in the result if the event request has more than one related event plan with a work date in October 2005.

8. List the plan number, event number, work date, and activity of event plans meeting the following two conditions: (1) the work date is in October 2005 and(2) the event is held in the "Football stadium". Your query must not use the facility number ("F100") of the football stadium. Pretend that the user knows only the facility name, not the facility number.

9. List the event number, event date, status, and estimated cost of events where there is an event plan managed by Mary Manager and the event is held in the football stadium in the period September 1 to December 31, 2005. Your query must not use the facility number ("F100") of the football stadium or the employee number("E101") of "Mary Manager". Pretend that the user knows only the facility name and employee name, not the facility number and employee number.

10. List the plan number, line number, resource name, number of resources(event plan line.number), location name, time start, and time end where the event is held at the basketball arena, the event plan has activity of "Cleanup" or "Setup",and the event plan has a work date in the period September 1 to December 31,2005.

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 10:07 AM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer