QUIZ 2.3B – TWO TABLE SQL QUERIESSQL

QUIZ 2.3B – TWO TABLE SQL QUERIES

SQL Week 2 Assignment 2.3B Questions

Question 1 (1 point)

Question 1 options:

[SQL Week 2 Question 200-001]

Print the first name, last name, ticket ID, ticket description, and duration of the employees who are assigned with a ticket(s). Sort them first alphabetically by first name (starting with letter A at the top) and then ascending by Duration.

This query should have resulted in employee Ben Johnson as your first several rows.

What is the top row idTicket for Ben?