Create queries to answer the following information requests. Note: Do not use the Access query builder (QBE) to create your queries – you should type the queries manually using SQL view/editor. The marking process of the queries for information requests may also consider the effectiveness of your SQL statements that have been used in the queries. It is important that your SQL statement must reflect the correct business logic & SQL syntax. (Note: Use enough sample data so that the output is produced by each and every query). Question 1. List the full names, phones, and ages for these patients whose home addresses are either in Brisbane or Gold Coast, and their ages are greater than 60 years old. Order by their family names. Question 2. There are many doctors in each hospital. But not every doctor participates in the treatment work due to their different specialties and other tasks. List the names and specialties of doctors, who are working at Princess Alexandra Hospital in Brisbane and have not participated in the treatment work of corona virus-infected patients. Question 3. List details of the patients from Rockhampton and their closely contacted persons. These details include patient’s full names and phones, closely contacted person’s full names and phones, as well as the contact process or scenario descriptions. Question 4. List the names, phones, and the number of virus tests for the patients who are from Brisbane. Question 5. Which hospitals have the highest number of respiratory machines? Find out the names of the hospitals, their phones, and the number of respiratory machines. Question 6. Which patients have been tested more than once on virus test? Show the patient names, phones, and the number of virus tests
The post Create queries to answer the following information requests. Note: Do not use the Access query builder (QBE) to create your queries – you should type the queries manually using SQL view/editor. appeared first on Best Custom Essay Writing Services | EssayBureau.com.
