How do you select the top 5 records from a table named orders? Which SQL clause is used to specify the columns to be returned by a query? How do you select records where the price is between 100 and 200? Which SQL function is used to find the maximum value in a column? How do you select records where the date is in the year 2023? Which SQL keyword is used to combine rows from two or more tables, based on a related column between them? How do you select records where the status is either ‘active’ or ‘pending’? Which SQL function is used to calculate the average value of a numeric column? How do you select records where the email column contains the domain ‘example.com’? Which SQL clause is used to specify the table to retrieve data from?