All About SQL Functions (
Page 1 of 6 )
In the last tutorial we left off with the SUM(column) function. In this article we will cover the remaining Aggregate Functions and the Scalar Functions. We might even make some fat jokes, some mama jokes, and as always, some nerd jokes.For this tutorial we are going to create a new database. Since I saw the Robot Chicken and Family Guy Star Wars episodes last night, and got like four hours of sleep to boot, we will be working with a Star Wars database. I know, I know. The writing in Star Wars was atrocious. Of course to avoid a lawsuit, we will be using my own version of Star Wars, call SilverWares: The Battle of the Knives and Spoons.
Before I give you the data though, let's do a little thing I like to call back-story. The story picks up with the Spoons trying to destroy the Knives. To do so, they have created a menacing weapon, a Spork, a Spoon with the built in ability to use...the Fork. Meanwhile, the Knives have uncovered their old Fork Master Gouda, a strange smelly alien whom they hope will teach young Luke Breadslicer the ways of the Fork.
Here is the data for our new database Employees:
|
Name |
Position |
Salary |
Side |
|
Darth Brooks |
Sith Lord/Country Singer |
$10,000 |
Spoon |
|
Darth Ladel |
Sith Master |
$100,000 |
Spoon |
|
Luke Breadslicer |
Fork Apprentice |
$20,000 |
Knife |
|
Gouda |
Fork Master |
$120,000 |
Knife |
|
Jabba the Cup |
Bounty Hunter Agent |
$500,000 |
Neutral |
|
Bubba Fett |
Red Neck Alien Bounty Hunter |
$1,000 |
Neutral |
|
Dance Solo |
Pilot for Hire |
$40,000 |
Knife |
|
Baklava |
Hairy Co-Pilot |
$25,000 |
Knife |
