SQL Foundations I Module 2

rearrange columns and use aliases

Only editable by group admins

Last updated August 24, 2016 at 1:05 PM
Evidence visible to public

Two queries will demonstrate rearranging columns and assigning column aliases. Provide a link to your work.

All posted evidence

Task 1

/*Task 1"*/

SELECT concat(Name, ' is on the team ', Team) name_team from Soccer_Players

SELECT name, `Salary(Millions)` from Soccer_Players order by `Salary(Millions)`

franciscocruz11 About 9 years ago

This is for the database in Konagora, chapter 2. http://edu.konagora.com/SQLsandbox.php#

Pastebin

CSC 176 Badge #2 - Pastebin.com

This is for the database in Konagora, chapter 2. I can't get SQLFiddle to work consistently enough and if I used my own DB I didn't think I'd be able to share it on badge for points.

randyiv About 9 years ago

link for query 1

http://sqlfiddle.com/#!9/9fe96/7

kfowler About 9 years ago

link for query 2

http://sqlfiddle.com/#!9/9fe96/5

kfowler About 9 years ago

Task 1

I have all of my queries listed here, grouped by task:
https://drive.google.com/open?id=0B5hBlRd1P7vEbXF6azltbXBHU0E

select NumberInStock, ItemNumber, ItemDescription from Products;
select LastName, FirstName, Address from Customers;

slewis52 About 9 years ago