Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

How would I use a single SELECT query to display the total count of sales, and the lowest, average, and highest sale price in SQL??

How would I use a single SELECT query to display the total count of sales, and the lowest, average, and highest sale price in SQL?? I have a SALES table and a VEHICLE table, but don't know how to JOIN. I've tried the following, but receive error message:

SQL> SELECT COUNT (*) AS
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question