I need a SQL Developer
Budget: $250 – $750 USD
1.Please write a SQL statement that considers the following:
a. The columns below represent tables related by common IDs. The order of the elements in the columns represents the order shown in the table. In addition, the tables may have hundreds of millions of records. Please write a query that shows visit frequency, animal volumes, and total costs for a physician that provided services in calendar year 2019 for animals aged below three (during their service date).
b. Using the same tables, please write a query that orders the visits from least to most expensive.
c. Using the tables above, please write a query that lists physicians in the Physician_2 column that are not in the physician_1 column.
d. Assume that the physician columns within the records table contain several variations on physician names that may include typos. How might you go about pulling data when asked about visit counts for several specific physicians?
2. You have written a long query (700+ lines) for a project and the query has been running for several hours. Can you list some possible reasons why this might happen? What are the potential fixes?
a. The columns below represent tables related by common IDs. The order of the elements in the columns represents the order shown in the table. In addition, the tables may have hundreds of millions of records. Please write a query that shows visit frequency, animal volumes, and total costs for a physician that provided services in calendar year 2019 for animals aged below three (during their service date).
b. Using the same tables, please write a query that orders the visits from least to most expensive.
c. Using the tables above, please write a query that lists physicians in the Physician_2 column that are not in the physician_1 column.
d. Assume that the physician columns within the records table contain several variations on physician names that may include typos. How might you go about pulling data when asked about visit counts for several specific physicians?
2. You have written a long query (700+ lines) for a project and the query has been running for several hours. Can you list some possible reasons why this might happen? What are the potential fixes?