Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

4. Not sure? Ask them.

Answered: 1 week ago