Title: What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_de Post by: Raspberry on May 16, 2016 What will be returned when the following SQL query is executed?
Select driver_no, count(*) as num_deliveries from deliveries group by driver_no having count(*) > 2; A) A listing of all drivers B) A listing of all drivers who made more than 2 deliveries C) A listing of the number of deliveries greater than 2 D) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries Title: Re: What will be returned when the following SQL query is executed? Select driver_no, count(*) as nu Post by: dorkalot on May 22, 2016 Content hidden
Title: Re: What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_de Post by: Raspberry on May 30, 2016 Thank you so much for this ^^
Title: Re: What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_de Post by: dorkalot on May 31, 2016 I'll stick around a little while if you need more of an explanation, otherwise thanks for marking the topic solved
|