About this document

SQL Database Creation and Queries Guide by Richa Joshi is a document available to read on EtoBox.

The document provides the SQL commands to create a database with 5 tables (CUSTOMER, SHIPMENT, TRUCK, CITY, POPULATION) including primary and foreign keys and constraints. It then lists 11 queries to perform on the populated database including finding city names and populations for shipments over 100 pounds, drivers for high revenue customers to large cities, and using views to filter customers by revenue for additional queries.

Author

Richa Joshi

Language

EN