Get a Freelance Job

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

Project #1

Save all of your code in Notepad as a *.txt file and attach it when you submit the project. Take screen shots of all successful implementation of each set of SQL.

Data Changes and SQL Statements

Resource: Table Queries assignment

Use the database and tables that are attached to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the store. Check results by selecting all columns from both tables.

Between, Like, and Union:

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.

Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.

Write a SQL query that uses the UNION of the two tables to produce a third table.

Save each query in a txt file and take a screen shot of its results and submit them as an attachment.

Group:

Use the updated database to write the following queries, using the SQL GROUP statement:

Select employees’ last names and group them by EEO-1 classification.

Select employees’ last names and group them by salary.

Select employees’ last names and group them by salary in their EEO-1 classification.

Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

Save all the SQL statements in a txt file and submit as an attachment.

Screen Shot

I need 20 Mafia-related images and names in each category below. I must have proper usage rights to them. Don’t steal images off the internet.

1. Weapon names and images (e.g. hand gun, grenade, AK-47 etc)
2. Armor names and images (e.g. rags, leather vest, chainmail etc)
3. Extra names and images (e.g. LSD, cocaine, silver necklace, charm, amulet etc)
4. Mission names and images (e.g. “Find Eddy” – a person, “Assassination” – a killer image, etc)
5. Territory names and images (e.g. internet cafe, street corner, casino, pub etc)

I just BOTH the images and their NAMES. Do NOT need to be have .psd file, web 2.0.
Sample of the type of images I am looking for: http://auths.com/mafia.jpg