Find Jobs
Hire Freelancers

SQL Homework Lab

$30-5000 USD

āļ—āļĩāđˆāļ—āļģāđ€āļŠāļĢāđ‡āļˆāđāļĨāđ‰āļ§
āđ‚āļžāļŠāļ•āđŒ āļĄāļēāļāļāļ§āđˆāļē 20 āļ›āļĩāļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

$30-5000 USD

āļŠāļģāļĢāļ°āđ€āļ‡āļīāļ™āđ€āļĄāļ·āđˆāļ­āļŠāđˆāļ‡āļ‡āļēāļ™
Using Transact SQL 1. Create a new database called Labs Create table employee with the following columns (enter 10 rows employees with data for each column) empID lastName firstName middleI address city phone email jobTitleCode hireDate salary Create table jobTitle with the following columns (enter 5 rows jobTitles) jobTitleCode jobTitle exempt/nonexempt min max 2. a. query ‘JOIN’ two tables and uses ‘BETWEEN’ to restrict record selection b. JOIN two tables and use ‘LIKE’ to restrict record selection. c. Create new table contractors (add 3 rows data). Use‘UNION’ to create a result set of all employees and contractors include select lists. d. Prepare a report showing all SQL statements and results. 3. Using SQL add 10 more employees to the database. Include one SQL insert statement. a. First, group rows by job title, providing counts of employees for each title. b. Then group rows by city, providing average salary for each city. c. Then group rows by exempt/nonexempt status, providing the highest and lowest employee salary for each group. d. Prepare a report showing SQL statements and results. 4. Using a CREATE statement, generate a “Terminated Employees?? table with the same columns as the employee table. a. add 5 employees to the new table. b. Using a UNION statement, create a result set of both active and terminated employees providing employees names, job titles, salaries, and an indicator of active or terminated. c. Using a SELECT statement with a sub-select (rather than a JOIN) to calculate the average salary for exempt employees and provide an additional column containing the literal “Exempt?? d. Prepare a report showing the SQL statements and results. Finally 5. Create a complete SQL Database utilizing JOIN, UNION, BETWEEN, LIKE First Construct a prototype of your project database, load it with several records of data by means of the insert command, and write SQL instructions for simple data retrieval. Prepare a report explaining the SQL statements and their results, demonstrating how data will be processed and accessed in the application. Include at least one UPDATE statement. Submit ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform Windows 2000 XP
āļĢāļŦāļąāļŠāđ‚āļ›āļĢāđ€āļˆāļāļ•āđŒ: 3021900

āđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāđ‚āļ›āļĢāđ€āļˆāļāļ•āđŒ

4 āļ‚āđ‰āļ­āđ€āļŠāļ™āļ­
āđ‚āļ›āļĢāđ€āļˆāļāļ•āđŒāļĢāļ°āļĒāļ°āđ„āļāļĨ
āđƒāļŠāđ‰āļ‡āļēāļ™āļ­āļĒāļđāđˆ 20 āļ›āļĩāļ—āļĩāđˆāļœāđˆāļēāļ™āļĄāļē

āļāļģāļĨāļąāļ‡āļĄāļ­āļ‡āļŦāļēāļāļēāļĢāļŠāļĢāđ‰āļēāļ‡āļĢāļēāļĒāđ„āļ”āđ‰āđƒāļŠāđˆāđ„āļŦāļĄ?

āļ›āļĢāļ°āđ‚āļĒāļŠāļ™āđŒāļ‚āļ­āļ‡āļāļēāļĢāļ›āļĢāļ°āļĄāļđāļĨāļāļąāļš Freelancer

āļāļģāļŦāļ™āļ”āļ‡āļšāļ›āļĢāļ°āļĄāļēāļ“āđāļĨāļ°āļāļĢāļ­āļšāđ€āļ§āļĨāļēāļ‚āļ­āļ‡āļ„āļļāļ“
āļĢāļąāļšāđ€āļ‡āļīāļ™āļˆāļēāļāļāļēāļĢāļ‡āļēāļ™āļ‚āļ­āļ‡āļ„āļļāļ“
āļ­āļ˜āļīāļšāļēāļĒāļ‚āđ‰āļ­āđ€āļŠāļ™āļ­āļ‚āļ­āļ‡āļ„āļļāļ“āđƒāļ™āļ āļēāļžāļĢāļ§āļĄ
āļĨāļ‡āļ—āļ°āđ€āļšāļĩāļĒāļ™āđāļĨāļ°āđ€āļŠāļ™āļ­āļĢāļēāļ„āļēāļŸāļĢāļĩ
āļŦāļĄāļ­āļšāļŦāļĄāļēāļĒāđƒāļŦāđ‰:
āļĢāļđāļ›āļ­āļ§āļēāļ•āļēāļĢāđŒāļ‚āļ­āļ‡āļœāļđāđ‰āđƒāļŠāđ‰
See private message.
$25.50 USD āđƒāļ™ 3 āļ§āļąāļ™
5.0 (1269 āļĢāļĩāļ§āļīāļ§)
7.5
7.5
4 freelancers are bidding on average $24 USD for this job
āļĢāļđāļ›āļ­āļ§āļēāļ•āļēāļĢāđŒāļ‚āļ­āļ‡āļœāļđāđ‰āđƒāļŠāđ‰
See private message.
$29.75 USD āđƒāļ™ 3 āļ§āļąāļ™
5.0 (137 āļĢāļĩāļ§āļīāļ§)
5.6
5.6
āļĢāļđāļ›āļ­āļ§āļēāļ•āļēāļĢāđŒāļ‚āļ­āļ‡āļœāļđāđ‰āđƒāļŠāđ‰
See private message.
$17 USD āđƒāļ™ 3 āļ§āļąāļ™
4.9 (26 āļĢāļĩāļ§āļīāļ§)
2.9
2.9
āļĢāļđāļ›āļ­āļ§āļēāļ•āļēāļĢāđŒāļ‚āļ­āļ‡āļœāļđāđ‰āđƒāļŠāđ‰
See private message.
$25.50 USD āđƒāļ™ 3 āļ§āļąāļ™
5.0 (5 āļĢāļĩāļ§āļīāļ§)
2.9
2.9

āđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāļĨāļđāļāļ„āđ‰āļē

āļ›āļąāļāļ˜āļ‡āļ‚āļ­āļ‡ UNITED STATES
United States
5.0
12
āđ€āļ›āđ‡āļ™āļŠāļĄāļēāļŠāļīāļāļ•āļąāđ‰āļ‡āđāļ•āđˆ āļ•.āļ„. 31, 2002

āļāļēāļĢāļĒāļ·āļ™āļĒāļąāļ™āļĨāļđāļāļ„āđ‰āļē

āļ‡āļēāļ™āļ­āļ·āđˆāļ™āđ† āļˆāļēāļāļĨāļđāļāļ„āđ‰āļēāļĢāļēāļĒāļ™āļĩāđ‰

Class project
$30-5000 USD
Using classes + inheritance
$30-5000 USD
C++ homework
$30-5000 USD
C++ lab3
$30-5000 USD
School Project UML
$30-100 USD
āļ‚āļ­āļšāļ„āļļāļ“! āđ€āļĢāļēāđ„āļ”āđ‰āļŠāđˆāļ‡āļĨāļīāļ‡āļāđŒāļŠāļģāļŦāļĢāļąāļšāđ€āļ„āļĢāļ”āļīāļ•āļŸāļĢāļĩāđƒāļŦāđ‰āļ„āļļāļ“āļ—āļēāļ‡āļ­āļĩāđ€āļĄāļĨāđāļĨāđ‰āļ§
āđ€āļāļīāļ”āļ‚āđ‰āļ­āļœāļīāļ”āļžāļĨāļēāļ”āļ‚āļ“āļ°āļŠāđˆāļ‡āļ­āļĩāđ€āļĄāļĨāļ‚āļ­āļ‡āļ„āļļāļ“ āļāļĢāļļāļ“āļēāļĨāļ­āļ‡āļ­āļĩāļāļ„āļĢāļąāđ‰āļ‡
āđ‚āļĨāđ‚āļāđ‰ Freelancer Thailand / āļ āļēāļĐāļēāđ„āļ—āļĒ āļŠāđˆāļ§āļĒāđ€āļŦāļĨāļ·āļ­āđāļĨāļ°āļŠāļ™āļąāļšāļŠāļ™āļļāļ™ Freelancerāļ›āļĢāļ°āđ€āļ āļ—āđ‚āļ›āļĢāđ€āļˆāļ„āļāļēāļĢāļ›āļĢāļ°āļāļ§āļ”Freelancerāļ­āļ‡āļ„āđŒāļāļĢāđāļžāđ‡āļāđ€āļāļˆāļŠāļĄāļēāļŠāļīāļāđ‚āļ„āļĢāļ‡āļāļēāļĢ Freelancer āļŠāļąāđ‰āļ™āđāļ™āļ§āļŦāļ™āđ‰āļēāļāļēāļĢāļˆāļąāļ”āļāļēāļĢāđ‚āļ›āļĢāđ€āļˆāļ„āļ‡āļēāļ™āđƒāļ™āļžāļ·āđ‰āļ™āļ—āļĩāđˆPhoto AnywhereāļŦāļ™āđ‰āļēāļˆāļąāļ”āđāļŠāļ”āļ‡āļœāļĨāļ‡āļēāļ™API āļŠāļģāļŦāļĢāļąāļšāļ™āļąāļāļžāļąāļ’āļ™āļēāđ„āļ”āđ‰āļĢāļąāļšāļāļēāļĢāļĒāļ·āļ™āļĒāļąāļ™Desktop App āđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāđ€āļĢāļēāļ§āļīāļ˜āļĩāđƒāļŠāđ‰āļ‡āļēāļ™āļ„āļ§āļēāļĄāļ›āļĨāļ­āļ”āļ āļąāļĒāļ™āļąāļāļĨāļ‡āļ—āļļāļ™āđāļœāļ™āļœāļąāļ‡āđ€āļ§āđ‡āļšāđ„āļ‹āļ•āđŒāđ€āļĢāļ·āđˆāļ­āļ‡āļĢāļēāļ§āļ‚āđˆāļēāļ§āļ­āļ­āļāļŠāļ·āđˆāļ­āļ—āļĩāļĄāļĢāļēāļ‡āļ§āļąāļĨāļ‚āđˆāļēāļ§āļ›āļĢāļ°āļŠāļēāļŠāļąāļĄāļžāļąāļ™āļ˜āđŒāļĢāđˆāļ§āļĄāļ‡āļēāļ™āļāļąāļšāđ€āļĢāļē āļ‚āđ‰āļ­āļāļģāļŦāļ™āļ”āļ™āđ‚āļĒāļšāļēāļĒāļ„āļ§āļēāļĄāđ€āļ›āđ‡āļ™āļŠāđˆāļ§āļ™āļ•āļąāļ§āļ‚āđ‰āļ­āļāļģāļŦāļ™āļ”āđāļĨāļ°āđ€āļ‡āļ·āđˆāļ­āļ™āđ„āļ‚āļ™āđ‚āļĒāļšāļēāļĒāļĨāļīāļ‚āļŠāļīāļ—āļ˜āļīāđŒāļ‚āđ‰āļ­āļžāļķāļ‡āļ›āļāļīāļšāļąāļ•āļīāļ„āđˆāļēāļ˜āļĢāļĢāļĄāđ€āļ™āļĩāļĒāļĄāđāļĨāļ°āļ„āđˆāļēāļšāļĢāļīāļāļēāļĢāļŦāļļāđ‰āļ™āļŠāđˆāļ§āļ™Escrow.comLoadshiftWarrior Forum āđāļ­āļ›āđ‚āļĨāđ‚āļāđ‰ Apple App Store āđ‚āļĨāđ‚āļāđ‰ Google Play
āđ„āļĄāđˆāļŠāļēāļĄāļēāļĢāļ–āļ„āļąāļ”āļĨāļ­āļāđ„āļ›āļĒāļąāļ‡āļ„āļĨāļīāļ›āļšāļ­āļĢāđŒāļ”āđ„āļ”āđ‰ āđ‚āļ›āļĢāļ”āļĨāļ­āļ‡āļ­āļĩāļāļ„āļĢāļąāđ‰āļ‡āļŦāļĨāļąāļ‡āļ›āļĢāļąāļšāđ€āļ›āļĨāļĩāđˆāļĒāļ™āļāļēāļĢāļ­āļ™āļļāļāļēāļ•
āļ„āļąāļ”āļĨāļ­āļāđ„āļ›āļĒāļąāļ‡āļ„āļĨāļīāļ›āļšāļ­āļĢāđŒāļ”āđāļĨāđ‰āļ§
āļœāļđāđ‰āđƒāļŠāđ‰āļ—āļĩāđˆāļĨāļ‡āļ—āļ°āđ€āļšāļĩāļĒāļ™ āļ‡āļēāļ™āļ—āļĩāđˆāļĄāļĩāļāļēāļĢāđ‚āļžāļŠāļ•āđŒāļ—āļąāđ‰āļ‡āļŦāļĄāļ”
Freelancer ÂŪ is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright ÂĐ 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
āļāļģāļĨāļąāļ‡āđ‚āļŦāļĨāļ”āļ•āļąāļ§āļ­āļĒāđˆāļēāļ‡
āđ„āļ”āđ‰āļĢāļąāļšāļ­āļ™āļļāļāļēāļ•āļŠāļģāļŦāļĢāļąāļšāļ•āļģāđāļŦāļ™āđˆāļ‡āļ—āļēāļ‡āļ āļđāļĄāļīāļĻāļēāļŠāļ•āļĢāđŒ
āđ€āļ‹āļŠāļŠāļąāđˆāļ™āļāļēāļĢāđ€āļ‚āđ‰āļēāļŠāļđāđˆāļĢāļ°āļšāļšāļ‚āļ­āļ‡āļ„āļļāļ“āļŦāļĄāļ”āļ­āļēāļĒāļļāđāļĨāļ°āļ„āļļāļ“āđ„āļ”āđ‰āļ­āļ­āļāļˆāļēāļāļĢāļ°āļšāļšāđāļĨāđ‰āļ§ āļāļĢāļļāļ“āļēāđ€āļ‚āđ‰āļēāļŠāļđāđˆāļĢāļ°āļšāļšāļ­āļĩāļāļ„āļĢāļąāđ‰āļ‡