Write the SQL query on the table VEHICLE that lists for each ...

[ec501234]

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]

Answer to Question 1

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

Answer to Question 2

TRUE

[ec501234]

Thanks for the timely response, appreciate it

[Joy Chen]

TYSM