Fun with SQL Basics

Who is your coding teacher?

• Mr. Adi

• Mr. Udin

• Mr. Sunny

• Mr. Ben

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Structured Query List

• Standard Query Language

What is SQL used for?

• SQL is used for writing operating system code.

• SQL is used for creating graphics and animations.

• SQL is used for designing web applications.

• SQL is used for managing and manipulating relational databases.

How can you display data in SQL?

• Use the INSERT statement to display data in SQL.

• Use the DELETE statement to display data in SQL.

• Use the SELECT statement to display data in SQL.

• Use the UPDATE statement to display data in SQL.

How do you sort data in SQL?

• Use the GROUP BY clause to sort data.

• Use the ORDER BY clause in your SQL query.

• Sort data by using the SELECT statement only.

• Data cannot be sorted in SQL.

What does the AND operator do in SQL?

• The AND operator returns true if all conditions are true.

• The AND operator combines two queries into one.

• The AND operator returns true if at least one condition is true.

• The AND operator is used to delete records from a table.

What does the OR operator do in SQL?

• The OR operator is used to delete records from a database.

• The OR operator is a function that calculates the average of two numbers.

• The OR operator combines conditions to return true only if all are met.

• The OR operator allows for multiple conditions in SQL queries, returning true if any condition is met.

What is the IN operator used for in SQL?

• The IN operator is used to join two tables.

• The IN operator is used to filter records based on a list of values.

• The IN operator is used to sort records in ascending order.

• The IN operator is used to update records in a database.

How do you use SUM in SQL?

• SELECT ADD(column_name) FROM table_name;

• SELECT SUM(column_name) FROM table_name;

• SELECT column_name FROM table_name WHERE SUM;

• SUM(column_name) AS total FROM table_name;

What is the purpose of the GROUP BY clause in SQL?

• To join two or more tables together.

• To sort the results of a query in descending order.

• To filter records based on a specific condition.

• To group rows that have the same values in specified columns.