{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

UMER_YASIN+p166097.docx - UMER YASIN P16-6097 Cs 16 A...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
UMER YASIN P16-6097 Cs 16 ‘A’ ASSINGMENT # 1 DATABASE SIR SHOAIB MUHAMMD
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Quries of part A: 1 mysql> select distinct city, zip ,state -> from customer; 2 mysql> select empname,department,email,phone -> from employee -> where phone like '3-%'; 3 mysql> select * -> from resourcetbl -> where rate between 10 and 20 -> order by rate; 4 mysql> select eventno,dateauth,status -> from eventrequest
Image of page 2
-> where dateauth like '2013-07-%'; 5 mysql> select locno,locname -> from facility f,location l -> where f.facno=l.facno and f.facname like'basket%'; 6 mysql> select planno,count(lineno) as eventplans ,sum(numberfld) -> from eventplanline -> group by planno -> having eventplans>=1; QURIES OF PART B:
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1 select a.eventno,dateheld,count(planno) from eventrequest a,eventplan b where a.eventno=b.eventno and workdate like '2013-12-%' group by b.eventno having count(planno) > 1; 2 mysql> select planno,a.eventno,workdate,activity -> from eventplan a,eventrequest -> where workdate like '2013-12-%' -> and eventrequest.facno in (select facno from facility where facname='basket%') -> and eventrequest.eventno=a.eventno; 3 mysql> select er.eventno,dateheld,status,estcost
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern