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

(a) a JOIN combining 2 relations.

(b) a JOIN combining 3 relations.

(c) a CROSS JOIN

(d) A SELF JOIN (if it makes sense for your database).

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