Get a Freelance Job

Write SQL statements to enter records into the Employee table for the 6 workers identified in the employee files for the administrative offices and the Del Mar store. Then use the database and tables to write the following queries.

(1) [1 pt] Check results by selecting the required columns from both tables (two separate queries). Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(2) [1 pt] Join two the two tables in the Kudler Fine Foods database and use BETWEEN to restrict record selection. Use salary to restrict data. The output should be arranged by salary high to low.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(3) [1 pt] Join two the two tables in the Kudler Fine Foods database and use BETWEEN to restrict record selection. Use hire dates to restrict data.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(4) [1 pt] Join two the two tables in the Kudler Fine Foods database and use LIKE to restrict record selection. Use Last Name to restrict data.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(5) [1 pt] Join two the two tables in the Kudler Fine Foods database and use a numerical comparison to restrict record selection. Use age to restrict data. The output should be arranged by age low to high.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(6) [1 pt] Use the ‘IN’ operator to find specific ages in a list from the Employee table. Pick specific ages of your choice. Display columns: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(7) [1 pt] Join two the two tables in the Kudler Fine Foods database and obtain only the employees’ last name and EEO-1 arranging the output by EEO-1 classification. Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(8) [1 pt] Join two the two tables in the Kudler Fine Foods database and use employees’ last name, salary and EEO-1 arranging them by salary (low to high). Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(9) [1 pt] Join two the two tables in the Kudler Fine Foods database and use employees’ last names, Exempt/Non-Exempt status arranging them by the status. Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(10) [1 pt] Join two the two tables in the Kudler Fine Foods database and use employees’ last names, arranging them by salary, job titles. The query must include a range of salaries and a specific status. You should pick a range and status so that there would be more than one record output. The output should display only the last name, salary and job title columns.
Provide the SQL and screen shot of the results of each of the above and submit these in a .doc.

Building on the previous database, write queries using the SQL SELECT
statement. Make sure to illustrate the salaries before and after the
modifications (Select *).

Using the database and tables from Week Three, write SQL statements to perform the following:

Using the same Kudler Fine Foods Database and Tables as well as building off all previous code:

Note. Select all data from both tables and produce a screen shot of each before and after you perform each item on the list below:

1. Increase all employees’ salaries with the selected EEO-1 classification by 10%.

2. Increase all employees’ salaries by 5%.

3. Choose an employee from the Employee table and delete that employee.

4. Calculate the average salary for all employees.

5. Calculate the maximum salaries for exempt and non-exempt employees.

6. Calculate the maximum salary for all employees.

7. Calculate the minimum salaries for exempt and non-exempt employees.

8. Calculate the minimum salary for all employees.

Otherwise, just stick to everything else we have been doing previously such as code documentation, screen shots, etc.

Hi there, we need some customization on our WHMCS as following:

1 – Exempt domains ending in (dot BR) from being charged, domains dot BR has to be free, and do not generate invoices at 0,00. We are currently using the bonus system (promocodes) to exempt these domains, but it generates the 0,00 invoices and email of payment confirmation, since the invoice is 0,00. We need another solution to exempt domains ending in dot BR then using the bonus system. So we could use the bonus system for what it is for. It probably can be done with CUSTOM HOOKS.

2 – Set “owndomain” (I will update my nameservers on an existing domain or I will register a new domain) as default (radio button selected) on the cart.php and let it selected even after the search for the domains availability.

3 – Change the way how LATE FEES are applied, currently the system adds only one price or percentage in only one time we need the system to add every single late day a late fee, and sum everyday with the past one, ex.: late fee is $1,00 per day, if the invoice is late 23 days, the late fee will be $23,00. As I already explained in other msg.

Thanks.

Hi,

I need a module or code modification in prestashop 1.2 (www.prestashop.com)that will make a certain group of customers tax exempt. Only customers in that group will be tax exempt and all others will be taxed as normal (set in prestashop back office).

Write SQL statements to perform the following:

Write SQL statements to perform the following:

Using the SQL CREATE statement, create the following two tables using the following fields:

Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table’s primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.

(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)

Using the fully populated Employee and Job_Title tables and data from Week Three, write queries using SQL UPDATE and DELETE statements. (2-1/2 points each)

Note: As a precaution, you should SELECT all of the data from both of your tables before you perform the following updates (i.e. UPDATE and DELETE statements) as a check that you’ll be affecting the correct data! But it’s the UPDATE and DELETE statements that actually change the data that you’ll be graded on. You don’t need to show the results of your “quick check” SELECT, but be sure to include all the SQL and SQL Server responses for your UPDATEs and DELETEs.

(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)

Using the database and tables from Week Two, write SQL statements and enter the records into the Employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables. You should now have 17 total employees and 9 total job titles (2 points)

Using the database and tables in Week Two, write SQL queries using Between, Like and Union: (1 point each)

Kudler Fine Foods is a

Kudler Fine Foods is a

Building on the previous database, write queries using the SQL SELECT statement. Make sure to illustrate the salaries before and after the modifications (Select *).

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 a SQL database completed in Express 2008. The details are as follows and it must be completed by Saturday the 25th:

Create an SQL server database for the Kudler Fine Foods Virtual Organization.

–Comment goes here
CREATE DATABASE CASEKudlerFineFoods
ON PRIMARY
(NAME = Case_KudlerDB_dat,
FILENAME = “C:POS410MyStuffCase_KudlerDB_dat.mdf”,
SIZE = 10MB,
MAXSIZE = 100MB
FILEGROWTH = 10%)

–Comment goes here
LOG ON
(NAME=”Case_KudlerDB_log”,
FILENAME=”C:POS410MyStuffCase_KudlerDB_log.ldf”,
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 20%)

(Note: Table connected by key means that if you have a primary key of Employee ID in the EMPLOYEE table, and Employee ID as a foreign key in the Job Title table, indicate the join in the data dictionary.)

Building on the previous database, write queries using the SQL SELECT statement. Make sure to illustrate the salaries before and after the modifications (Select *).