1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
alekssr [168]
3 years ago
5

Create a query that will list all technician names, employee numbers, and year hired in order by year hired (Newest to Oldest).

Computers and Technology
1 answer:
Oliga [24]3 years ago
7 0

Answer:

SELECT TECHNAME, EMPNUM, YEAR FROM EMPLOYEE ORDER BY YEAR DESC

Explanation:

The table definition is not given;

However, I'll make the following assumptions

Table Name:

Employee

Columns:

Technician name will be represented with Techname

Employee number will be represented with Empnum

Year Hired will be represented with Year

Having said that; the sql code is as follows:

<em>SELECT TECHNAME, EMPNUM, YEAR FROM EMPLOYEE ORDER BY YEAR DESC</em>

<em></em>

The newest year hired will be the largest of the years;

<em>Take for instance:</em>

An employee hired in 2020 is new compared to an employee hired in 2019

This implies that the year has to be sorted in descending order to maintain the from newest to oldest.

You might be interested in
45 points pls help
Artemon [7]

Answer:

Repetition.

Explanation:

hope it helps u

can u mark me as brainliest

8 0
3 years ago
Read 2 more answers
Keith has to carry out a photo shoot to capture images of the ocean during the monsoons. What is a recommended practice when sho
Semmy [17]

Answer:

Answer is A: place absorbent chemical packets in the camera cover

Explanation:

Keith is required to carry adequate gear while going for a shoot. And in this case, he should carry anything that will protect his camera from the ocean and rainwater. By anything, I mean anything that Keith will use to stay dry. Using an air conditioner would be the worst idea. An air conditioner might blow the air towards your camera. Placing the camera in its case will ensure that it is dry and Keith will keep on shooting. Placing absorbent chemical packets in the camera cover will ensure that any water droplets that might fall on the cover of the camera will be absorbed. The point here is to keep dry.

6 0
3 years ago
Which of the following is CORRECT about database managementsystem's languages?
scZoUnD [109]

Answer:

Data manipulation languages are used for the retrieval of the,insertion,deletion and modification of data.

Explanation:

Data Manipulation Languages(DML) are used to insert,delete,update,modify the data in the database.

The commands used to do these operations are as following:-

INSERT INTO :-This command is used to insert values in the database.

DELETE:-It is used to delete existing records from the table.

UPDATE:- It is used to modify the records in the table.

SELECT:- It is used to select data from database.

3 0
3 years ago
Choose the 3 Points in good story telling
Sidana [21]

Answer:

1.Choose a clear central message 2. Embrace conflict 3.Have a clear structure  

Explanation:

8 0
2 years ago
Match the design feature or area of expertise with the benefit or increase in usability it offers. 1. standardized placement of
RSB [31]
<span>The match of the design feature or area of expertise with the benefit or increase in usability it offers would be the following:

 1. standardized placement of elements simplify reading and increase the transparency of the interface
2. plain fonts ensures software fulfills its function in an efficient manner that recognizes and solves likely issues of use
3. cultural fluency takes advantage of preexisting customer expectations regarding layout
4. well-structured program logic enables the designer to make appropriate choices in style and tone for the intended end user</span>
3 0
3 years ago
Other questions:
  • What allows multiple computers to join the same network
    11·1 answer
  • Ports on the motherboard can be disabled or enabled in ____ setup. RAM Firmware Northbridge BIOS
    8·1 answer
  • A computerized spreadsheet program is useful for
    6·2 answers
  • Use ONE SQL statement to show the total number of actual hours for each customer. In the output, show customer id and the total
    15·1 answer
  • If you want to change the smart quote settings, what steps should you follow to find them?
    5·1 answer
  • Write a short program using Python that will:
    10·1 answer
  • A message M is encapsulated by the TCP, IP and Ethernet protocols in that order as it travels down a protocol stack. What does t
    5·1 answer
  • I don’t understand this, i need help
    7·1 answer
  • Write a function that takes in two parallel lists: a list of times (in increasing order), and a list of distance traveled by tha
    13·1 answer
  • Please help me !!
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!