SQL commands (P2)

Question 1

SQL query for selecting ProductName, SupplierID from a table called Products where Price = 21 and Stock < 30

Answer 1

SELECT ProductName, SupplierID FROM Products WHERE Price == 21 AND Stock < 30

Question 2

Select all the records in a table called Products where “Sauce” appears in ProductName

Answer 2

SELECT * FROM Products WHERE ProductName LIKE “Sauce”

Question 3

You have 2 tables, one table called ACCOUNTS with fields:

Acc_No, Customer_ID, Balance, Acc_Type

and another called CUSTOMERS:

Customer_ID, Family_Name, Zip_Code, Phone

Create an SQL query to select the names of customers and balance whose account balance is greater than $300,000

Answer 3

SELECT CUSTOMERS.Family_Name, ACCOUNTS.Balance FROM CUSTOMERS INNER JOIN ACCOUNTS ON ACCOUNTS.CustomerID = CUSTOMERS.CustomerID WHERE ACCOUTNS.Balance > 300000