From the following tables,write a query to get.the histogram of specializes of the unique physicians who have done the procedures but never did prescribe anything 1213Patient treatment tablePatient Id | Event NameRadiationChemotherapyBiopsy| Physician ID00 0000000 00Immunosuppressants0000BTKI00 000004.Radiation5.4.ChemotherapyBiopsyChemotherapy0009Event category table|CategoryProcedureEvent NameChemotherapyProcedureImmunosuppressants PrescriptionPrescriptionRadiationBTKIBiopsyTestPhysician Speciality TablePhysician Id specialtyPage 21 3 Physician Speciality TablePhysician Id | specialtyRadiologistOncologistHematologistOncologistPathologistOncologist0o0000004000.0009Sample Output,specialty speciality count

Patient treatment table Patient Id | Event Name | Physician ID1 Radiation 10002 Chemotherapy 20001…

Patient treatment table Patient Id Event Name Radiation | Physician ID 000 Chemotherapy Biopsy Immunosuppressants 2000 0000 000 0 BTKI 0000 Radiation 0000 Chemotherapy Biopsy Chemotherapy 0000 0000 0009 Event category table Event Name Chemotherapy Radiation | Category Procedure Procedure Immunosuppressants Prescription Prescription Test BTKI Biopsy Physician Speciality Table Physician Id 1 specialty obe vwww

Patient treatment table Patient Id Event Name Radiation | Physician ID 000 Chemotherapy Biopsy Immunosuppressants 2000 0000 000 0 BTKI 0000 Radiation 0000 Chemotherapy Biopsy Chemotherapy 0000 0000 0009 Event category table Event Name Chemotherapy Radiation | Category Procedure Procedure Immunosuppressants Prescription Prescription Test BTKI Biopsy Physician Speciality Table Physician Id 1 specialty obe vwww

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

Q: What is the difference between a UNION query and an EXCEPT (MINUS) query?

A: The UNION operation comprises of logical OR while INTERSECT is a logical AND. The EXCEPT(MINUS)…

Q: Write a query to list all client ID(name and last names) and client type who have never checked out…

A: Given: Write a query to list all client ID(name and last names) and client type who have never…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

Q: Write a query to find employees whose salary is equal to the salary of at least one employee in…

Q: Write an appropriate SQL query to determine it there are any students that are not registered tor…

A: ANSWER IN STEP 2:

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: Question Breakdown: According to the problem statement provided we should upgrade the SQL query to…

Q: What is the difference between a UNION query and an EXCEPT (MINUS) query?

A: Given: The result that is included in the first table but absent from the second table is obtained…

Q: Write a query to display the author ID and the number of books written by that author.Sort the…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: inventory, i.e. the sum of all products on hand for each brand id. Sort the output by brand id in…

A: Here have to determine sql query for given problem.

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: Given:

Q: Write a query to list month and profit for 2008 and sort the list ascending by profit. What month is…

A: Note: You did not mention which SQL we have follow so we did it in MySql CREATE TABLE Product…

Q: Write an SQL Query that will show the following attributes from theORDERS table: ORDER #, CUSTOMER…

A: “ORDER BY” Clause: SQL contains "ORDER BY” clause in order to sort rows. The values get sorted in…

Q: Write a SQL query to find the second highest salary from the table Employee(Eno, EName, Salary,…

A: Given Table: Employee(Eno, EName, Salary, Department) Requirement: Write a SQL query to find the…

Q: address Write a query to display the guest names who are from Ooty. For instance, the guest name…

A: Required: We have to write a SQL query that displays the guest names who are from Ooty and the…

Q: Write a query to display the author ID, first and last name for all authors that have never written…

A: We indeed to provide SQL query to display the author ID, first and last name for all authors that…

Q: 1. Write a SQL query to list first name, last name and rank of only professors whose rank is…

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

Q: Write an SQL query to fetch the no. of workers for each department in the descending order.

A: Question. Write an SQL query to fetch the no. of workers for each department in the descending…

Q: Write an SQL query to find all customers whose name (either last name or first name) contains…

A: The following SQL queries can be used to achieve various tasks related to data searching and…

Q: ery to Show how many indices in employee table and what are their names?

A: Program Approach: 1- In this query required group by clause and aggregate function. 2- With the…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: As per the given problem we have to develop a SQL query to display the guest names who are from…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

From the following tables,write a query to get.the histogram of specializes of the unique physicians who have done the procedures but never did prescribe anything

1213
Patient treatment table
Patient Id | Event Name
Radiation
Chemotherapy
Biopsy
| Physician ID
00 0
0000
00 00
Immunosuppressants
0000
BTKI
00 00
000
4.
Radiation
5.
4.
Chemotherapy
Biopsy
Chemotherapy
0009
Event category table
|Category
Procedure
Event Name
Chemotherapy
Procedure
Immunosuppressants Prescription
Prescription
Radiation
BTKI
Biopsy
Test
Physician Speciality Table
Physician Id specialty
Page 21 3

Physician Speciality Table
Physician Id | specialty
Radiologist
Oncologist
Hematologist
Oncologist
Pathologist
Oncologist
0o00
0000
4000.
0009
Sample Output,
specialty speciality count

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

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

Write a query to display the author ID, first and last name for all authors that have never written a book with the subject Programming. Sort the results by author's last name. (Figure P8.64)
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta govind" should be displayed as "Geeta Govind". Give alias name as GUESTNAME. Sort the result based on Guest Name. Hint: Address can be in any case. Use like operator to fetch city from address. RESORT MANAGEMENT SYSTEM Pointofinterest Town Manager Number Varchar(30) PK townID managerID PK pointID Number PK Number townname varchar(30) describe Varchar(30) name opentime varchar(10) PC 王 state longitude latitude varchar(30) varchar(30) varchar(30) address varchar(30) %3 closetime varchar(10) city varchar(20) HAS phone varchar(15) summertemp wintertemp sealevel FK townID Number Number Number Number Resort Guest Review PK resortID Number guestID Number PK FK,PK guestiD Number varchar(30) resortName varchar(30) name FK.PK resortID Number street varchar(30) MANADES address varchar(30) + dateofreview Date townname varchar(30) country varchar(20) BOOKS FK townid Number email varchar(30) comments…
Write a SQL query to display the patron ID, first and last name, and patron type for all patrons whose last name begins with the letter “C”, sorted by patron ID (Figure P7.73).
What is the difference between an EXCEPT (MINUS) query and a UNION query?
The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee num-ber, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2015, and December 5, 2015. If there is a tie for most units sold, sort the output by employee last name
Run a query or multiple queries if needed to report on final exam average based on thestudent’s age. Give an average for all students 40 and below and an average for all studentsover 40. This report will be used continuously so you cannot just figure out what 40 years agotoday was. You need to use the date to calculate their age somewhere in your solution