Help here with SQL Selecting Multiple Columns Write a query the ProductName, ProductionDate

Question

Write a query to select the ProductName, ProductionDate and ExpirationDate.

Use the SELECT statement and separate the required columns by commas.

This is how I understand it

SELECT * ProductName, ProductionDate, ExpirationDate
From products;

https://www.sololearn.com/coach/981?ref=app

Answer 1

DELETE From products
WHERE ExpireDate < 1; SELECT * FROM Products

Answer 2

select productname, productiondate, expirationdate from products
Yogurt, 2020-11-19,2021-01-19
Juice, 2020-10-10,2022-10-10
Milk, 2020-08-19, 2020-08-23

It says there a syntax around yogurt and 2020. What can the problem be?

Answer 3

remove the * That means all fields.

Answer 4

Thanks

Answer 5

SELECT productname,productiondate,expirationdate
FROM products;

Why won't this work says no input 😭

Answer 6

Thanks that worked 😀

Answer 7

SELECT product name,production date,expiration date
FROM products;

Answer 8

SELECT productname, productiondate, expirationdate From Products;

Answer 9

When buying food, it is important to make sure it is fresh and not expired.
You are given the following 'Products' list:

Answer 10

SELECT ProductName,ProductionDate,ExpirationDate FROM Products;

Answer 11

SELECT ProductName, ProductionName, ExpirationDate
From Product;

Answer 12

DELETE From products
WHERE ExpireDate < 1; SELECT * FROM Products

Answer 13

You said

from productlist; instead of
from products;

Answer 14

Oh thanks, it's done 👍

Answer 15

SELECT ProductName, ProductionDate, ExpirationDate
From products;

Answer 16

SELECT ProductName, ProductionDate, ExpirationDate
from productlist;

No output ???