A2.pdf - > Select country SUM(amount AS total FROM Payments...

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

View Full Document Right Arrow Icon
> Select country, SUM(amount) AS total FROM Payments JOIN Customers on Payments.customerNumber = Customers.customerNumber GROUP BY country + ------------ + ---------- + | country | total | + ------------ + ---------- + | Australia | 509385.81999999995 | | Austria | 136119.99 | | Belgium | 91471.03 | | Canada | 205911.86 | | Denmark | 197356.3 | | Finland | 295149.35 | | France | 965750.5800000001 | | Germany | 196470.99 | | Hong Kong | 45480.79 | | Ireland | 49898.270000000004 | | Italy | 325254.55000000005 | | Japan | 167909.95 | | New Zealand | 392486.59 | | Norway | 270846.3 |
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
| Philippines | 87468.3 | | Singapore | 261671.59999999998 | | Spain | 994438.5300000003 | | Sweden | 120457.09 | | Switzerland | 108777.92 | | UK | 391503.89999999997 | | USA | 3040029.5199999996 | + ------------ + ---------- + 21 rows > Select * FROM Customers JOIN Employees on Customers.salesRepEmployeeNumber = Employees.employeeNumber WHERE customerName REGEXP '[k]{2}' GROUP BY lastName + ------------------- + ----------------- + -------------------- + --------------------- + ---------- + ----------------- + ------------- ---- + --------- + ---------- + --------------- + ------------ + --------------------------- + ---------------- + --------------------- + ------------------- + ------------- + -------------- + -------------- + ---------- + -------------- + ------------- + --------------- +
Image of page 2
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