Question

Last year (2022) there was a bug in the product system. For some products that were added in that year, the year_added value was not set in the data. As the year the product was added may have an impact on the price of the product, this is important information to have. Write a query to determine how many products have the year_added value missing. Your output should be a single column, missing year, with a single row giving the number of missing values.

Answer 1

The student's question regarding a SQL query to count missing 'year_added' values for products is answered using a COUNT function and IS NULL condition in SQL.

Step-by-step explanation:

The question asks for a SQL query to count the number of products with a missing year_added value in a database. To accomplish this, we can use the SQL COUNT function in combination with the IS NULL condition to determine the total number of products that were added in the year 2022 but do not have the year_added data recorded.

The SQL query would look something like this:

SELECT COUNT(*) AS 'missing_year'
FROM products
WHERE year_added IS NULL;

This query will return a single column, missing_year, with a single row that provides the count of missing year_added values for products.