SQL Basics

Contents

Database
2 items
What is Database?
Database Management Systems
Printing
4 items
Hello World SQL
Change column name
Simple math in SQL
Math operators in SQL
Basics
3 items
Show all data
Select one column
Select specific columns
Where Clause
3 items
Peter Jackson movies
Highly rated movies
David Fincher movies
Aggregate Functions
11 items
Count of rows
Meta Score values
Missing Meta Score values
Maximum IMDB score
Minimum IMDB score
Total runtime
Gross of all the movies
Total runtime in hours
Average runtime
Average runtime in hours
Average Gross of all the movies