SQL Summary - SELECT basics

query.sql

…

Expected output

Lesson notes

Summary - SELECT basics

Combine column selection, aliases and literals to write a query.

Summary - SELECT basics

In this group you learned the SELECT basics:

SELECT names columns, FROM names the table
* picks all columns; otherwise list them by name
AS gives columns a result name
Literals and calculations are allowed

Now you will combine these in one query.

Exercise Summary - SELECT basics

Select the name column and twice the price aliased as dbl from products.

Show example solution

SELECT name, price * 2 AS cift
FROM products

Test yourself

Which is a valid SELECT query?
- FROM customers SELECT name;
- SELECT name FROM customers;
- SELECT name customers;
- customers SELECT name;
Show answer

SELECT name FROM customers; — SELECT comes before FROM.
Summary - SELECT basics: match the terms

SELECT

choose columns
FROM

specify table
AS

give alias
*

all columns

Next lesson: What is WHERE?