4.3. Track Open Tickets by Priority

Try these first

1. 1.

   What does the SELECT statement do in an SQL query?

   Hint

   Think about what you want to display from the database.

2. 2.

   What does the WHERE clause accomplish?

   Hint

   Consider how you can narrow down data results.

3. 3.

   What SQL clause is used to filter results based on specific conditions?

   • SELECT
   • WHERE
   • GROUP BY

   Hint

   Think about how you would limit data to specific criteria.

4. 4.

   True or False: COUNT() can be used to aggregate rows from a database table.

   • True
   • False

   Hint

   Think about the role of COUNT in summarizing data.

5. 5.

   How would you modify the SQL query to track open tickets not just by priority but also by the department handling them?

   Hint

   Think about what you need to add to retrieve more specific information.

6. 6.

   Consider a situation where the ticket status needs to be updated after a fixed period. How might SQL be used to identify tickets that need follow-ups?

   Hint

   Focus on how to filter by date to identify tickets that are older.