Loading the lesson
Loading the lesson
Search AllRounder.ai
Search the courses, subjects, tracks, games and features, or jump straight to a page.
Search the courses, subjects, tracks, games and features, or jump straight to a page.
3 cards from this section. Quick, good the night before a test.
What does SQL stand for?
Think about the terms used for working with databases.
Write a SQL query to find the lowest salary from the employees table.
You need to order the salaries, but which order is needed for the lowest?
What SQL statement do we use to retrieve specific columns from a table?
Think of the word that indicates choosing something from a group.
True or False: The AVERAGEIF function in Excel can ignore empty cells.
Does this function include blank cells in its calculations?
Write a SQL query to find the second highest salary from the employees table without using the LIMIT clause.
Think about how you can exclude the highest salary in your subquery.
Create a complex Excel formula that calculates the average sales only for products sold over 50 units in the range B1:B20.
Use a condition to filter your range before averaging it.
5 more questions in this section. Enroll free to practise them all.
Enroll free