Consider the following Employee Table and the SQL query given: id Date Work_hour 1 2020-10-18 8 1 2020-10-17 8 1 2020-10-16 9 2 2020-10-18 7 2…

Consider the following Employee Table and the SQL query given:

idDateWork_hour
12020-10-188
12020-10-178
12020-10-169
22020-10-187
22020-10-168
32020-10-166
SELECT id, sum(work_hour) from Employee Where Work_hour>6 Group BY ID;

How many rows are returned by the SQL query?

  1. a) 3
  2. b) 4
  3. c) 2
  4. d) 0

From the Janata Bank Assistant Network Engineer 2020 – Written exam, question 30 of 68.

More from this paper