Study tips 1Z0-051

Which query would give the required result?

Which SQL statements are valid?

Which statement is true regarding the above query if one of the values generated by the sub query is NULL?

Which two queries would give the required output?

Which statement is true regarding the outcome of the above query?

Which clause in the above SQL statement causes the error?

Which statement is true regarding sub queries?

Which two queries give the required result?

Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table?

Which ORDER BY clause are valid for the above query?