In class 12 SQL II submission file

.docx

School

Saint Louis University *

*We aren’t endorsed by this school

Course

3100

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

4

Uploaded by imteazmahmud2

Report
In class 12 SQL II Name: _____________ Q21: SQL Command: select Id,fullname, price,eps from stock where price<500 and eps>5; Result Screenshot: Q29: SQL Command: SELECT * from stock where fullname like '%INC%'; Result Screenshot:
Q32: SQL Command: SELECT sector, AVG(eps) as AvgEPSPerSector from stock group by sector HAVING AvgEPSPerSector>10 order by sector desc; Result Screenshot: Q33: SQL Command: SELECT *, CASE WHEN eps is null then NULL WHEN eps<5 then 'low' when eps<10 then 'medium' else 'high' end as EPSLevel from stock;
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help