Self-Check 0 of 13 passing

Each query is checked three ways: it must run without error, its result must include the required columns (aliases checked case-insensitively; extra columns are fine), and it must return the expected number of rows. Some queries also have spot checks against known values in the seed data. Passing the self-check does not by itself award marks, but a query that fails here will not meet the specification in the assessment brief.

Key	Query	Page	Status	Detail
q01	Product catalogue needs: product_id, product_name, price, stock_qty	products.php	Not attempted	Write this query in student/queries.php.
q02	Low stock report needs: product_name, stock_qty, reorder_level	products.php	Not attempted	Write this query in student/queries.php.
q03	Marketing mailing list needs: first_name, last_name, email, town	customers.php	Not attempted	Write this query in student/queries.php.
q04	Recent orders needs: order_id, order_date, customer_name	orders.php	Not attempted	Write this query in student/queries.php.
q05	Order line details needs: order_id, order_date, product_name, quantity, unit_price, line_total	orders.php	Not attempted	Write this query in student/queries.php.
q06	Revenue by category needs: category_name, total_revenue	reports.php	Not attempted	Write this query in student/queries.php.
q07	Staff sales leaderboard needs: staff_name, branch_name, orders_handled, total_revenue	reports.php	Not attempted	Write this query in student/queries.php.
q08	Monthly revenue trend needs: sale_month, total_revenue	reports.php	Not attempted	Write this query in student/queries.php.
q09	High-performing branches needs: branch_name, total_revenue	reports.php	Not attempted	Write this query in student/queries.php.
q10	Customers yet to order needs: first_name, last_name, email, joined_date	customers.php	Not attempted	Write this query in student/queries.php.
q11	VIP customers (above average spend) needs: customer_name, total_spent	customers.php	Not attempted	Write this query in student/queries.php.
q12	Best seller by category needs: category_name, product_name, units_sold	reports.php	Not attempted	Write this query in student/queries.php.
c1	Directors' Challenge: branch peak month needs: branch_name, peak_month, peak_revenue, pct_of_total	challenge.php	Not attempted	Write this query in student/queries.php.