SQL Query: Please fix error below.

SELECT product_name, list_price FROM Categories

WHERE list_price > AVG(list_price)

ORDER BY list_price DESC

Msg 147, Level 15, State 1, Line 2 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

___________________________________________________________________________________________

SQL Query: Please fix error below.

SELECT email_address, order_id,

SUM(order) AS [Order Total] FROM Order_Items

GROUP BY email_address, order_id;

SELECT TOP 1 email_address, [Order Total] FROM

(SELECT email_address, order_id, SUM(order) AS [Order Total]

FROM Order_Items GROUP BY email_address, order_id) x

ORDER BY [Order Total] DESC

Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'order'. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'order'.

___________________________________________________________________________________________

SQL Query: Please fix error below.

SELECT emailaddress, From Customers

Select orderid,orderdate FROM Orders a WHERE orderdate = (SELECT MIN (a.orderdate) FROM Orders a WHERE emailaddress =emailaddress)

SQL Query: Please fix error below.

Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'From'.

SQLQuery1.sql - VD...DENTS phelsc (51)) ELECT email_address, order id, sUM(order) AS [Order Total] FROM Order_Items GROUP BY email_address, order_id; SELECT TOP 1 email_address, [Order Total] FROM (SELECT email_address, order_id, SUM(order) AS [Order Total]. FROM Order_Items GROUP BY email_address, order_id) x ORDER BY [rder Total] DESC Messages Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'order'. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'order'. Completion time: 2023-02-26T12:47:37.9529102-05:00