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

-> 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:

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

Recently Viewed

Study on the go

What students are saying

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.

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

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.

Dana
University of Pennsylvania ‘17, Course Hero Intern

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.