Question: sql quickly please 4. Write a query to display any four information of the employees whose phone number contains the number (value) 4 more than

sql quickly please sql quickly please 4. Write a query to display any four information

4. Write a query to display any four information of the employees whose phone number contains the number (value) "4" more than five times. Use the Employees table to display the result in descending order of employee id. [3 Marks)

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!

ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number. Modify the...

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

***********PLEASE USE THIS TABLES SQL************ DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept...

Write a query to display the employees name and hire date for all employees in the same department as 'Blake'. Exclude 'Blake'. Create a query to display the employee number and name for all...

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified....

Required: Use the Employees table (copy and paste the code in SQL command line) Write the PL/SQL based on the requirement in each number. Note: Sample output is just a guide, it does not necessarily...

In this project, you will use a Database Management System to create and manipulate a very small database system for hospital Your task is to improve it to some extent and implement the design as...

If you were the administrator of the organization, how could you use internal audits to uncover the fraud before an external audit occurred? What type of internal audit occurred? What type of...

Using inverters, AND gates, and OR gates, construct the gates shown in Fig. 15.6. f(x, y) f(x, y) = x y EXCLUSIVE-OR gate g(x, y) g(x, y) xy NAND gate h(x, y) h(x, y) x + y NOR gate

Question 4 7 1 pts In vertical partitioning, each partition must have a copy of the primary key of the table. True False

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

4. What kinds of businesses are most likely to benefit from using cloud computing? Why? Cloud computing is taking off. The biggest players in the cloud computing marketplace include Amazon Web...

5-10 Qantas Airways, Australias leading airline, faces cost pressures from high fuel prices and lower levels of global airline traffic. To remain competitive, the airline must find ways to keep costs...

5-13 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...