A.) To filter rows in a table B.) To order rows in a table C.) combine rows from two or more tables based on a related column D.) To calculate the average value of a column
A.) GROUP BY clause B.) ORDER BY clause C.) HAVING clause D.) WHERE clause
A.) To calculate the average value of a column B.) To count the number of rows in a result set C.) To round a numeric value to the nearest integer D.) To extract a substring from a string
A.) DELETE B.) INSERT C.) UPDATE D.) ALTER
A.) To return all rows from both tables, including unmatched rows B.) To return only rows that have matching values in both tables C.) To return all rows from the left table and matching rows from the right table D.) To return all rows from the right table and matching rows from the left table
A.) INT B.) VARCHAR C.) BLOB D.) DATE
A.) To create a new table B.) To count the number of rows in a table C.) To conditionally return different values based on a specified condition D.) To order rows in a result set
A.) AVG() B.) SUM() C.) MAX() D.) MIN()
A.) To combine rows from two or more tables into a single result set B.) To perform a cross join between two tables C.) To filter rows in a table D.) To order rows in a result set
A.) To delete all rows from a table B.) To remove a column from a table C.) To change the data type of a column D.) To remove a table from the database