Question: Problem 1. Please write ONE SQL statement for each of the following tasks using tables created in Problem 1. Note that you can only use

 Problem 1. Please write ONE SQL statement for each of the

Problem 1. Please write ONE SQL statement for each of the following tasks using tables created in Problem 1. Note that you can only use conditions specified in the task description and cannot manually look up data and add conditions. E.g., in task 1, you cannot manually look up category ID for carpet cleaner. You want to make sure your code will work regardless of what data are in the database (e.g., whether carpet cleaner has a category ID of 1 or 100). [100 points, 20 points each] Task 1: Return names and emails of authors of the paper titled 'A novel approach of mining EHR data Task 2: Return reviewer ID, review decision, and review comments of the paper titled 'Comparing big data systems' Task 3: Return paper title and number of authors for each paper. Task 4: Return names of authors who have at least two papers. Task 5: List names of authors who have co-authored with Dr. Chen. Hint: use self join

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!