Implement the following types of queries in SQL by referring to the relational schema below (2 queries for each category):

(a) a Subquery.

(b) a Correlated Subquery.

(c) UNION.

(d) UNION ALL.

(e) INTERSECT.

(f) EXCEPT.

For each query, define the query in English. (e.g. what does it retrieve?) specify how it can be implemented Using SQL. (write the query in SQL)

Consumer 12 -name 12 limitid) OfRelational Schema! CONSUMER (consumer_id, consumertype, C APPLICATION Consumer id app.id, app-type, app-name) CREDIT CARD ( ald, cr-descr, cr-consumered, DOCUMENT ( app.id, doccid, doc-type doc_name, REPORT (appuid , repatid report scare, ceportstype LIMITS Card limited linj tu balance, latt_type) REWARD ( cruid , reward.id, coordilype, putandum ( reward , rastarda PURCHASE cod purchaseid, purchase times & Functional Dependences purchase interest 1 12