To retrive the data from any table:
SELECT * FROM <table_name>



To retrive any subset data from the table called orderInventoryRecord:

SELECT 
orderInvId, 
orderInvNumber, 
orderInvTotalUnits, 
orderInvQuotedPrice 
FROM orderInventoryRecord



To retrive any subset data from the table called orderCustomerRecord:

SELECT 
orderId, 
orderNumber, 
orderDate, 
customerNumber 
FROM orderCustomerRecord



To retrive any subset data from the table called inventoryItem:

SELECT 
itemId, 
itemNumber, 
itemDescription, 
itemUnitsInStock, 
itemClass, 
itemWarehouseLocation, 
itemUnitPrice  
FROM inventoryItem



To retrive any subset data from the table called customer:

SELECT 
customerId, 
customerNumber, 
customerName, 
customerAddress, 
customerBalance, 
customerCreditLimit, 
repNumber  
FROM customer



To retrive any subset data from the table called salesRep:

SELECT 
salesRepKeyId, 
repNumber, 
repFirstName, 
repLastName, 
repAddress, 
repComissionTotal, 
repComissionRate  
FROM salesRep



To query data comparatively from any given table:

SELECT xxx FROM yyy WHERE zzz > 2000;
such as:
SELECT itemNumber, itemUnitPrice FROM inventoryItem WHERE itemUnitPrice > 500;



To update data in any given table:

UPDATE xxx SET yyy='<updated-value>' WHERE yyy='<value>';
such as:
UPDATE inventoryItem SET itemUnitPrice='450' WHERE itemUnitPrice='400';



To delete a row in any given table:

DELETE FROM xxx WHERE yyy='<value>';
such as:
DELETE FROM salesRep WHERE repNumber='2';



To sort a query of any given table:

SELECT * from xxx ORDER BY yyy ASC;
such as:
SELECT * from salesRep ORDER BY repLastName ASC;
or:
SELECT * from salesRep ORDER BY repLastName DESC;



To delete any given table:

DROP TABLE xxx;
such as:
DROP TABLE test_table;



To delete a database use:

DROP DATABASE IF EXISTS <database_name_here>;