Data Manipulation using SQL

Data Manipulation using SQL

0%

1. Database and Nested Queries

We shall take a look at the database we'll work with and how we can create a query inside another query.

SQL In Statement

Challenge In Statement

SQL Exists Statement

2. SQL Joining Tables

Learn how to join and work with multiple tables.

SQL Left & Right Join

SQL Full Outer Join

SQL Union

3. SQL Tasks

Try creating queries with no limits on how you should do that. Use all your knowledge from previous chapters!

Challenge: Albums with Two Songs

Challenge: the Biggest Album

Challenge: Rating of Singers

Challenge: Decades

Challenge: Two Singers

Challenge: Solo vs Bands

Challenge: Solo Albums

Challenge: Singers Stats

Зміст курсу

Data Manipulation using SQL

Data Manipulation using SQL

1. Database and Nested Queries

Database SQL In Statement Challenge In Statement SQL Exists Statement

2. SQL Joining Tables

SQL Inner Join SQL Joins SQL Left & Right Join SQL Full Outer Join SQL Union

3. SQL Tasks

Challenge: Albums with Two Songs Challenge: the Biggest Album Challenge: Rating of Singers Challenge: Decades Challenge: Two Singers Challenge: Solo vs Bands Challenge: Solo Albums Challenge: Singers Stats

SQL Union

UNION is an operator that concatenates results of different SQL queries:


              1234567
            
--do not run this query
SELECT columns FROM table1
UNION
SELECT columns FROM table2
UNION
...
SELECT columns FROM tableN

There is also an operator UNION ALL, and the difference is that UNION returns distinct values, unlike UNION ALL.

Requirements for using UNION operators:

number of columns in SELECT should be the same
data types and order of columns should be the same

Завдання

Swipe to show code editor

You want to get some info about songs from three decades: 1970s, 1980s, and 1990s. Find the prices of the cheapest and the most expensive songs for each decade in separate queries. You're free to use JOIN, BETWEEN, or any other operators, but you should do three separate queries and concatenate them with UNION.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 2. Розділ 5

toggle bottom row

SQL Union

UNION is an operator that concatenates results of different SQL queries:


              1234567
            
--do not run this query
SELECT columns FROM table1
UNION
SELECT columns FROM table2
UNION
...
SELECT columns FROM tableN

There is also an operator UNION ALL, and the difference is that UNION returns distinct values, unlike UNION ALL.

Requirements for using UNION operators:

number of columns in SELECT should be the same
data types and order of columns should be the same

Завдання

Swipe to show code editor

You want to get some info about songs from three decades: 1970s, 1980s, and 1990s. Find the prices of the cheapest and the most expensive songs for each decade in separate queries. You're free to use JOIN, BETWEEN, or any other operators, but you should do three separate queries and concatenate them with UNION.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 2. Розділ 5

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

some-alt