SQL Query Practice

Consider the following SQL query: `SELECT Name FROM Students WHERE Age > 18;`. What does this query do?

• It provides all details of students aged over 18.

• It selects the names of students who are older than 18.

• It selects the ages of students who are older than 18.

• It selects all students regardless of age.

Given the SQL query: `SELECT COUNT(*) FROM Orders WHERE Status = 'Shipped';`, what is the purpose of this query?

• To count the total number of orders.

• To count the number of orders that have been shipped.

• To list all orders that have been shipped.

• To update the status of orders to 'Shipped'.

Which SQL query would you use to find the total number of employees in the 'Marketing' department?

• `SELECT COUNT(*) FROM Staff WHERE Division = 'Marketing';`

• `SELECT SUM(*) FROM Employees WHERE Department = 'Marketing';`

• `SELECT TOTAL(*) FROM Workers WHERE Section = 'Marketing';`

• `SELECT NUMBER(*) FROM Personnel WHERE Group = 'Marketing';`

What is the correct SQL query to retrieve the an ItemName from the Inventory table of all products that cost above $100?

(a)  

Consider the SQL query: `SELECT FirstName, LastName FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;`. What does this query do?

• It lists all customers and their orders.

• It lists the first and last names of customers who have placed orders.

• It lists all orders regardless of customer.

• It lists the first and last name of customers who have not placed any orders.