Question

group by sust.cida Q2 (7 Points) Show customer id (CID) for customers who have spent 30,000 or more with the company in 2019. Money is considered "spent" when the entire work order is completed as recorded in workorder.completionDate. (Correct query will find customer 2). Use ONE SQL statement. select workarder.id from workorder, ord where and total > 30000 AND EXTRACT(YEAR FROM workorder.completiondate) = 2019, I WRONG Q3 (7 Points) Use ONE SQL statement to find all orders created on a Monday. In the output, show ordid. CreatedDate, Day of the week. Q4 (7 Points) Calculate the total revenue from all tasks that were finished during the 4h quarter of 2018. You can use common knowledge and data mentioned in this question; you cannot use data that reside in any of the tables but not mentioned in this question. Use ONE SQL statement. Q5 (7 Points) Use ONE SQL statement accomplish all of the following: ds D. Focus na

I need the answer to #2 listed above. This is the code I have come up with, and it is wrong. I am new to this and need help.

Answer 1

Question 2:

Answer:

Select workorder.custid from workorder, ord where where workorder.custid = ord.custid and total>=30000 and to_char(completiondate, ‘yyyy’)=2019;

[ Only Q #2 was answered as you mentioned ]