Question

1.Describe the way subqueries can be used in the WHERE, HAVING, FROM and SELECT clauses of a SELECT statement. (In 200 to 300 words)

Answer 1

Where: It filters a result which all the data to select condition. fulfill a specified Ex? SELECT * FROM country name WHERE Status='rich! one filters all the people from a country who are The above rich. Having: This is used instead of WHERE with aggregate functions. En SELECT COUNT(rich), country name FROM status GROUP BY country HAVING COUNT (rich) > 50 count of rich people greater The above enample filters out than so, Countries. FROM: data This is used to specify which table to select or delete from. SELECT name from data; Ex: SELECT: This is used to select data from database. The data returned is stored in a result table, called the result set. EN SELECT name, age from data;