Hi everyone, I am on aggregate functions in MYSQL in the course, when Mosh introduces COUNT(*), which is supposed to return the total amount of rows including ones with NULL, I have 19 rows and it is counting only 17 (Shown in photos). This might be obvious to everyone, but I am curious on what is happening, I did refresh the schemas and the invoices table. Thank you in advance.
My code is: SELECT
MAX(invoice_total) AS highest,
MIN(invoice_total) AS lowest,
AVG(invoice_total) AS average,
SUM(invoice_total) AS total,
COUNT(*)
FROM invoices
The output on the table it creates shows: COUNT(*) as 17
