SQL
EXAMPLE 1
Input:
SELECT name, continent, area, population, gdp, capital
FROM world
WHERE name = “Algeria”
Output:
Algeria,Africa,238174,38700000,207021000000,Algiers
EXAMPLE 2
Input:
SELECT name
FROM world
WHERE population >
(SELECT population
FROM world
WHERE name = “Algeria”)
Output:
Argentina
EXAM-STYLE QUESTION 1
Student Name, Subject, Grade
Results
Subject = "Art"
EXAMPLE 1
Input:
SELECT name, continent, area, population, gdp, capital
FROM world
WHERE name = “Algeria”
Output:
Algeria,Africa,238174,38700000,207021000000,Algiers
EXAMPLE 2
Input:
SELECT name
FROM world
WHERE population >
(SELECT population
FROM world
WHERE name = “Algeria”)
Output:
Argentina
EXAM-STYLE QUESTION 1
Student Name, Subject, Grade
Results
Subject = "Art"