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

(a) retrieve all the tuples of a relation. Display all the attribute values.

(b) retrieve all the tuples of a relation. Display some but not all attribute values.

(c) retrieve the tuples that satisfy some condition.

(d) retrieve the tuples that satisfy some condition. Query should include the LIKE operator.

(e) retrieve the tuples that satisfy some condition. Output should be sorted sorting on a single attribute.

(f) retrieve the tuples that satisfy some condition. Output should be sorted sorting on more than one attribute.

(g) implement a query that groups a relation on a specific attribute, and applies SUM, COUNT, MIN, MAX aggregate functions on each group.

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 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