Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
darwesh
Starting Member
1 Post |
Posted - 2013-11-04 : 09:02:24
|
Hello Guys,Can you help me to solve this question? Employee Customerid name age salary id name city industry type1 ben 61 140000 4 bamsonic Cologne J 2 bob 34 44000 6 ranasung Leslieburg J5 chris 34 40000 7 Vamony Arlington B7 Dan 41 52000 9 grange Marina B8 Ken 57 11500011 Joe 38 38000OrderId orderdate Customer_id Employee_id Amount10 8/2/2006 4 2 54020 1/30/2009 4 8 180030 7/14/2005 9 1 46040 1/29/2008 7 2 240050 2/3/2008 6 7 60060 3/2/2008 6 7 72070 5/6/2008 9 7 150a. The names of all employees that have an order with Bamsonic.b. The names of all employees that do not have any order with Bamsonic.c.The names of employees that have 2 or more orders. Write a SQL statement to insert rows into a table called high_value_employee(name, age), where an employee must have a salary of 100,000 or greater to be included in the table.e. Write the appropriate "CREATE TABLE" statements for all base tables (employee, customer, order) and shortly describe the choices you made. f. Which things would you personally improve about this schema? Where do you see potential problems |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-04 : 10:02:19
|
this seems to be an assignment question. Can we see what you tried yet?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|