Question: 1. Write the SQL query for the given condition below. [5 marks] Table Name: Employee Castomer Name Contact Nam Salary City Dept Desg Customer! D

1. Write the SQL query for the given condition below. [5 marks] Table Name: Employee Castomer Name Contact Nam Salary City Dept Desg Customer! D 1 2 3 4 5 Pink Rose Yellow Green Red Applc Orange Mango Pineapple Banana 700 900 1000 600 750 Sohar Muscat Buraimi Burimi Nizwa Marketing Admin Production Safety R&D Manager HR Technician Security Lab Assistant a. to display the all the details where the salary is less than or equal to 700. Answer: b. to display the only the customerid, dept and desg details for the employee who belongs to Buraimi. Answer: c. to update the value of the salary by 100 for the employees whose salary is less than 700. Answer: d. to find the maximum salary. Answer: e. to drop a column named city

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!

Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not...

Technical Assessment - Business System Analyst The questions below are to test your knowledge of SQL databases and ability to write reporting queries, while understanding the data and paying...

For the conceptual schemata of the database, establish an environment for the execution of simple and advanced queries in Oracle. The global schemata is as below EMP (ENUM, NAME, SAL, TAX, MGR, DNUM)...

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

Database Design Report and Implementation - Please ignore requirement for screenshot, just need assistance with the actual SQL queries so I can insert them into the data myself for the output....

Complete the Following: 1. Consider the data distribution of the Company database, where the whole database (shown in Figure 5.6) is stored at site 1, and the replicated fragments shown in Figure...

Northwind Database Query Tool Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program: Print order total...

Implement the table design in SQL SERVER by creating the database as Recruitment. Perform the following SQL Query and provide the clear screen shot that show the SQL Query and the output for that...

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

Create one sql script file to complete the following. You cannot run separate SQL statements for the homework. You will also need to place a semicolon after each SQL statement, a requirement for SQL...

Khanna Inc. had the following transactions, information and balances in its accounting records for fiscal 2021: (CAD = Canadian dollars; USD = U.S. dollars) E Balance (CAD) Dec 31/21 CAD treasury...

Finance professionals often evaluate the quality of earnings by looking at the difference between earnings and cash flows. In particular, financial analysts often compute the difference between (i)...

4 How many of the following items are found on the income statement, rather than the balance sheet? Sales Notes payable ( due in six months ) Bonds payable ( mature in 1 0 years ) Common stock 0 2 5...

1) (16 points) A furnace wall is composed of an inner 0.106 -m layer of fireclay brick (k=1.13W/mK) and a 0.635cm layer of stainless steel (k=23W/mK) on the outside surface. The inside air...

What is the purpose of a Position Control Table? What relationships to other Compensation Tables would be important?

What Data Elements are usually found in the Job Family Table, and what is the relationship of the Job Family Table to the Occupation Table?

What is the relationship between the Internal Staff Compensation Target Table and the Internal Staff Compensation Data Table?