Simple Database App

BookID Title UnitPrice Author Quantity SupplierID SubjectID
1 book1 12.34 author1 5 3 1
2 book2 56.78 author2 2 3 1
3 book3 90.12 author3 10 2 1
4 book4 34.56 author4 12 3 2
5 book5 78.90 author5 5 2 2
6 book6 12.34 author6 30 1 3
7 book7 56.90 author2 17 3 4
8 book8 33.44 author7 2 1 3
CustomerID LastName FirstName Phone
1 lastname1 firstname1 334-001-001
2 lastname2 firstname2 334-002-002
3 lastname3 firstname3 334-003-003
4 lastname4 firstname4 334-004-004
EmployeeID LastName FirstName
1 lastname5 firstname5
2 lastname6 firstname6
3 lastname6 firstname9
OrderID CustomerID EmployeeID OrderDate ShippedDate ShipperID
1 1 1 2016-08-01 2016-08-03 1
2 1 2 2016-08-04
3 2 1 2016-08-01 2016-08-04 2
4 4 2 2016-08-04 2016-08-04 1
5 1 1 2016-08-04 2016-08-05 1
6 4 2 2016-08-04 2016-08-05 1
7 3 1 2016-08-04 2016-08-04 1
BookID OrderID Quantity
1 1 2
4 1 1
6 2 2
7 2 3
5 3 1
3 4 2
4 4 1
7 4 1
1 5 1
1 6 2
1 7 1
ShipperID ShpperName
1 shipper1
2 shipper2
3 shipper3
4 shipper4
SubjectID CategoryName
1 category1
2 category2
3 category3
4 category4
5 category5
SupplierID CompanyName ContactLastName ContactFirstName Phone
1 supplier1 company1 company1 1111111111
2 supplier2 company2 company2 2147483647
3 supplier3 company3 company3 2147483647
4 supplier4 company4 2147483647
Tables_in_yzy0050db
db_book
db_customer
db_employee
db_order
db_order_detail
db_shipper
db_subject
db_supplier

Hint: This app only supports one query at a time.
Please do not submit multiple queries at a time, it will not work.
Please note that you are not allowed to modify tables (i.e. DROP, UPDATE, INSERT, CREATE, or DELETE).

Click HERE to see some sample questions for practice