Practice SQL questions based on store database page 95 of textbook
1. List the last and first names of all employees whose age is >40 years.
Select emp_lname, emp_fname
From employee
Where emp_dob < #11/20/1961#;
emp_lname emp_fname
Greenboro Lottie
Smith Robert
Ogallo Roberto
Eindsmar Jack
Archialo Barry
2. List the last and first names of all employees who work in stores that have made
more than $1,000,000.00 in YTD sales, sorted by employee last name.
Select emp_fname, emp_lname
From employee, store
Where store_ytd_sales > 1000000
And store.store_code = employee.store_code
order by emp_lname;
emp_fname emp_lname
Barry Archialo
Jack Eindsmar
Elizabeth Johnsson
Robert Mckee
Howard Olenko
Nancy Ratula
Cary Renselaer
Jennie Rumpersfro
Alan Washington
3. List the total sales of all stores in the West region
Select store_ytd_sales
From store, region
Where region.region_descript = “West”
And region.region_code = store.region_code;
store_ytd_sales
$1,003,455.76
$1,421,987.39
$944,568.56
