Answered: 2 Q3: Find the top 2 accounts with the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

ANSWER ONLY QUESTION 2

SQL

Use appropriate clauses and filters to run the query

with minimum time complexity.

Try to avoid running the queries on unnecessary rows

and columns.

Share the queries along with a brief description of

the code in a python file, so that the

results are reproducible.

Q1: Write a query to find the doctors working in a company having more

ratings than their supervisors

EMPLOYEES RATING TABLE

employee id employee name rating senior id designation

1 george 9 3 doctor

2 micheal 8 4 doctor

3 mary 6 null supervisor

4 steve 9 null supervisor

For the above table GEORGE has more rating than his

supervisor

2 Q3: Find the top 2 accounts with the maximum number of unique patients on a monthly
basis.
Patient logs table
Account Id | date | Patient Id
1 2-1-2020 100
1 27-1-2020 200
2 1-1-2020 300
2 21-1-2020 400
2 21-1-2020 300
2 1-1-2020 500
3 20-1-2020 400
1 4-3-2020 500
sample output
Month |Account ID | no of unique patients
January 2 3
January 1 2
March 3 1
*Note: Prefer the Account Id with the least value in case of same number of

SAMPLE ANSWER ---

#query description
query1=”query for question 1”
#query description
query2=”query for question 2”
#query description
query3=”query for question 3”

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions