SQL Foundations I Module 3

Use functions in queries

Only editable by group admins

  • Last updated November 13, 2017 at 4:52 PM
  • Evidence visible to public
Four of the above queries will use a mix of single-row and aggregate functions. Submit a link to show your work.

All posted evidence

Four queries using joins as well as a mix of single-row and aggregate functions

http://sqlfiddle.com/#!9/ea89d8e/13
http://sqlfiddle.com/#!9/ea89d8e/14
http://sqlfiddle.com/#!9/ea89d8e/17
http://sqlfiddle.com/#!9/ea89d8e/20
mpurnell1 About 7 years ago

Used functions: UPPER, CONCAT, ROUND and SUM in 4 above queries from Task 1 and Task 2

UPPER in Query 1
CONCAT and UPPER in Query 2
CONCAT and ROUND in Query 3
SUM in Query 4
jmfisher About 7 years ago

Four queries using a mix of single-row and aggregate functions

http://sqlfiddle.com/#!9/ea89d8e/8
http://sqlfiddle.com/#!9/ea89d8e/9
http://sqlfiddle.com/#!9/ea89d8e/10
http://sqlfiddle.com/#!9/ea89d8e/11

mpurnell1 About 7 years ago

# tells you how many countries are listed # FIRST person born IN list # most recent death # LENGTH OF the longest first_name

Pastebin

[SQL] # tells you how many countries are listed SELECT COUNT(DISTINCT countries.count - Pastebin.com

vbecu1 About 8 years ago

Finds the SUM of bytes and COUNT of files in directories.

Puu

https://puu.sh/sT6IZ/99415d120d.png

jaco About 8 years ago

CONCATENATES first and last names into a full name.

Puu

https://puu.sh/sT66S/ee47138b69.png

jaco About 8 years ago

Finds the movie COUNT for each country in a pseudo table.

Puu

https://puu.sh/sT5lC/7b16b33357.png

jaco About 8 years ago

Finds LENGTH of movie and alt titles.

Puu

https://puu.sh/sT5wW/a906cd115f.png

jaco About 8 years ago

I didn't finish all of them, but I did my best! This is a link to all of them.

Google Docs

MODULE 3 :: TASK 1

Task 1 >> NATURAL JOIN SELECT * FROM Customers NATURAL JOIN Orders; --Task 2 >> INNER JOINS SELECT * FROM Orders INNER JOIN Products USING (ItemNumber); SELECT Orders.OrderNumber, Customers.Address, ItemNumber, ItemDescription, ItemLocation FROM Products INNER JOIN Orders USING (ItemNumber)...
slewis52 About 8 years ago

Kept it simple and used the Konagora DB http://edu.konagora.com/SQLsandbox.php

Pastebin

SELECT * FROM credits NATURAL JOIN movie_title_ft_index2 WHERE title_wor - Pastebin.com

Pastebin PRO Accounts CHRISTMAS SPECIAL! For a limited time only get 50% discount on a LIFETIME PRO account! Offer Ends Soon!
randyiv About 8 years ago

4. Functions in queries!

Hidden-shore-76374

Devblog

kfowler About 8 years ago