David Nguyen

Series

SQL

SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

Posts in this series

[SQL] 1633. Percentage of Users Attended a Contest

David NguyenDavid Nguyen
Nov 24, 20242 min read

Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar...

[SQL] 1633. Percentage of Users Attended a Contest

[SQL] 1251. Average Selling Price

David NguyenDavid Nguyen
Nov 21, 20242 min read

Table: Prices +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | start_date | date ...

[SQL] 1251. Average Selling Price

[SQL] 620. Not Boring Movies

David NguyenDavid Nguyen
Nov 21, 20242 min read

Table: Cinema +----------------+----------+ | Column Name | Type | +----------------+----------+ | id | int | | movie ...

[SQL] 620. Not Boring Movies

[SQL] 570. Managers with at Least 5 Direct Reports

David NguyenDavid Nguyen
Nov 21, 20241 min read

Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | |...

[SQL] 570. Managers with at Least 5 Direct Reports

[SQL] 1280. Students and Examinations

David NguyenDavid Nguyen
Nov 21, 20243 min read

Table: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name |...

[SQL] 1280. Students and Examinations

[SQL] 197. Rising Temperature

David NguyenDavid Nguyen
Nov 21, 20242 min read

Table: Weather +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | recordDate | date ...

[SQL] 197. Rising Temperature