Question

Task 2.1.3. List the job id and purchase order id for any purchase order involving a quantity greater than 50 or involving item id 'IRN For example: Result job.id po.id 004 004 004 006 CCc Answer: (penalty regime 0 %) Check You should write queries to answer the following questions. Example output is also provided and needs to match exactly (including heading names). You need to pass all the quiz items to gain the checkpoint. Use 'AS' to change the column name where appropriate. It is recommended that you develop the answer to the question in SQLite outside of FLO. Add each query to a file one at a time (as the previous one is determined to be correct), for example, printing.query.ts2.1.sql In SQLite you can use the command.read to execute the SQL commands contained in a file, e.g sqlites read printing.query.ts2.1.sq if you turn on command echo it will also output the sql to make it for a tutor to help you sqlite .echo ON

Answer 1

Here is the query, which will get the Job_id and po_id from the table Result where the quantity is greater than 50 or item_id is equal to IRN.

In this query Purchase is the table name, we are fetching Job_id and po_id where the quantity is greater than 50 or Item_id equal to 'IRN'.

SQL>>SELECT job_id,po_id FROM Purchase WHERE quantity>50 OR item_id='IRN'