ClassicModels — SQL Practice

Select a chapter from the sidebar to see its exercises.

ClassicModels Schema

customers customerNumbercustomerNamecontactLastNamecontactFirstNamephoneaddressLine1addressLine2citystatepostalCodecountrysalesRepEmployeeNumbercreditLimitcustomerLocation 122 rows
employees employeeNumberlastNamefirstNameextensionemailreportsTojobTitleofficeCode 23 rows
offices officeCodecityphoneaddressLine1addressLine2statecountrypostalCodeterritoryofficeLocation 7 rows
orderdetails orderNumberproductCodequantityOrderedpriceEachorderLineNumber 2996 rows
orders orderNumberorderDaterequiredDateshippedDatestatuscommentscustomerNumber 326 rows
payments checkNumberpaymentDateamountcustomerNumber 273 rows
productlines productLinetextDescriptionhtmlDescriptionimage 7 rows
products productCodeproductNameproductScaleproductVendorproductDescriptionquantityInStockbuyPriceMSRPproductLine 110 rows
SELECT only — ClassicModels
Write a query or click an exercise to load it.