This is my submission for Task 4 of the SQL Developer Internship, created using MySQL Workbench. I focused on writing SQL queries to apply aggregate functions (SUM, COUNT, AVG), GROUP BY, and HAVING, ...
Question 1: Write a query to find the total number of invoices in the invoices table. SELECT COUNT(*) AS total_invoices FROM invoices; Question 2: Write a query to determine the total amount of all ...