Author Question: Write the SQL query on the table VEHICLE that lists for each owner the OwnerID, OwnerName, and the ... (Read 36 times)

ec501234 · **on:** Jul 7, 2018

Write the SQL query on the table VEHICLE that lists for each owner the OwnerID, OwnerName, and the number of vehicles each owner owns, sorted by the number of vehicles each owner owns (in ascending order.)

What will be an ideal response?

Question 2

CRM provides support for front-end customer facing functionality.

Indicate whether the statement is true or false

jojobee318 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

SELECT ownerid, ownername, COUNT()
FROM vehicle
GROUP BY ownerid, ownername
ORDER BY COUNT();

Answer to Question 2

TRUE