Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need 10, 11, and 13. Tried to run them but SQL didn't take them. Hope you can see. 10. List the name of every owner
Need 10, 11, and 13. Tried to run them but SQL didn't take them. Hope you can see.
10. List the name of every owner who owns a pet that has visited a clinic located in the city Fullerton. 11. List the name and type of pet for every pet that has been treated more than 2 days and spent more than $100 for treatment. 13. Find the name and type of pet that has received the most expensive treatment.
https://livesqLoracle.com/apex/Rp-590:1:1 15271571 62533 NORPs Apps homepage New Tab ORACLE Live SQL Feedback Helpscottwe@warhawks.ulm.edu Home SQL Worksheet Clear Actionsa Save Ran SQL Worksheet HERE clinicNo (SELECT clinicNo FAO) Clinic 14HERE city. Fullerton , ) AND ONnerNo IN (SELECT omerio ,ROM Pet); 3 SELECT p.petName, P-pettype, FROM Pet P. Treatnent t, Pettreatment pt 4 WHERE pt.petNo - p-petNo AMD pt-treatho Hit. treatio ANo t cost 100 AND (pt.endDate: pt.startbate) 2; 6 SELECT p.pethane, p-petType FRom Pet p, Treatnent t, PetTreatnent pt 7 WHERE pt.petNo -p.petNo Ai0 pt.treato . treatNo AND ost (SELECT max(cost) FROM Treatnentil My Session Schema Quick SQL My Scripts code library ORACLE Integrated Cloud
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started