How_to_retrieve_data_from_a_single_table/exer_5C22.sql

After 1/1/2018
114
37966.19
6.00

use ap;
SELECT 'After 1/1/2018' AS selection_date,
       COUNT(*) AS number_of_invoices,
       MAX(invoice_total) AS highest_invoice_total,
       MIN(invoice_total) AS lowest_invoice_total
FROM invoices  
WHERE invoice_date > '01/01/2018';