SQL, Subqueries, and Databases
Not what you're looking for?
Create the following queries and save them all in a file called P1.SQL. Please note that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. Define what database to use with a USE statement. Please refer to the attached file for more information.
- Get the full details of the employee table.
- Get the full details of the employees who work in store S2.
- Get the full details of the promotions with a budget greater than $100,000.
- Get the employee number and promotion number for employees with unknown (NULL) jobs who work on promotion P2.
- Using a subquery, get the first and last names of the employees who work in the Orange Appeal store.
- Using a subquery, get full details of all the employees whose stores are located in Orlando.
Purchase this Solution
Solution Summary
This is a solution looking at SQL based on information on employees working in the Orange Appeal store.
Solution Preview
Dear Student,
Initially, you should created a database Employees with the tables and create the queries which you need. I am attaching the queries in sql file. You should open the file in notepad.
These are the queries in sql file.
use Employees
- Get the full details of the employee table.
...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
C# variables and classes
This quiz contains questions about C# classes and variables.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Basic Networking Questions
This quiz consists of some basic networking questions.
Javscript Basics
Quiz on basics of javascript programming language.