Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL List the plan number, event number, work date, and activity of event plans meeting the following two conditions: ( 1 ) the work date
SQL List the plan number, event number, work date, and activity of event plans meeting the following two conditions: the work date is in December and the event is held in the Basketball arena Your query must not use the facility number F of the basketball arena in the WHERE clause. Pretend that the user knows only the facility name, not the facility number. Thus, the WHERE clause should not have a condition involving the facility number compared to a constant F
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 basketball arena in the period October to December Your query must not use the facility number F of the basketball arena or the employee number E of Mary Manager in the WHERE clause. Pretend that the user knows only facility name and employee name, not the facility number and employee number. Thus, the WHERE clause should not have conditions involving the facility number or employee number compared to constant values.
List the plan number, line number, resource name, number of resources eventplanlinenumber locationname, time start, and time end where the event is held at the basketball arena, the event plan has activity of activity of Operation and the event plan has a work date in the period October to December Your query must not use the facility number F of the basketball arena in the WHERE clause. Thus, the WHERE clause should not have a condition involving the facility number to a constant F EventRequest
EventPlan
EventPlanLine
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started