Selecting Multiple Columns ?SQL

Question

In sql lesson 4.2,when buying food... How can i use select statement to code?

Answer 1

SELECT ProductName, ProductionDate, ExpirationDate from Products; this is the answer to the question

Answer 2

This code

SELECT ProductName, ProductionDate, ExpirationDate from Products;

Always results in error as the productname values appeared with small first letter ( ex: jogurt instead of Jogurt )

Answer 3

SELECT ProductName, ProductionDate, ExpirationDate from Products

Answer 4

Syntax of the SQL SELECT Statement:
SELECT ​column_list FROM table

In the given problem, we have a table named "Products" and from that table, we have to select three columns whose names are given. So, we simply have to select those columns by mentioning them.

SELECT ProductName, ProductionDate, ExpirationDate from Products;

Answer 5

Try this code it works!!!

SELECT InitCap(ProductName) as ProductName, ProductionDate, ExpirationDate FROM Products;