SQL

SQL Exercise

Imagine you work for Disney in their Star Wars division. Your manager has asked you to use SQL to retrieve the data from the database and complete the tasks below.

The name of the table is StarWars. The table columns are as follows:

Name
Birth_Year
Mass
Gender

Using SQL statements, complete the tasks below:

Retrieve all of the records from the database
Retrieve the name and birth year of the characters
Retrieve only the male characters
Retrieve the characters that weigh more than 70 kilograms

The results will output below:

Display answers for tasks:

Select * From StarWars; -- or -- Select Name, Birth_Year, Mass, Gender From StarWars;

Select Name, Birth_Year From StarWars;

Select * From StarWars Where Gender = "Male"; -- or -- Select Name, Birth_Year, Mass, Gender From StarWars Where Gender = "Male";

Select * From StarWars Where Mass > 70 -- or -- Select Name, Birth_Year, Mass, Gender, From StarWars Where Mass > 70;

This shouldn't display