Question: For Northwind database, create an sql command that from the employees table, writes the name and earnings in one column - name the column salary,

For Northwind database, create an sql command that from the employees table, writes the name and earnings in one column - name the column salary, for people from region 20 and 50 with earnings between 2000 and 7000, sort the columns by surname (Earnings should be counted as sales of the employee in the Order Details table via the Orders table)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!