priyankasoni05027 priyankasoni05027
  • 14-02-2021
  • Computers and Technology
contestada

write query to get the max and min salary of job_id 101​

Respuesta :

tonb
tonb tonb
  • 14-02-2021

Answer:

SELECT  MAX(salary), MIN(salary) FROM salaries WHERE job_id=101

Explanation:

Assumptions were made on the column and table names...

Answer Link

Otras preguntas

What is .368 written in expanded form?
why are quebec and ontario known as canadas economic heart
Write 75 as the product of its prime factors. (2 marks)
A shop is giving 20% discount in a sale. A shirt in the shop normally costs $60. How much does it cost in the sale?
What role does carbon dioxide play in plant life processes
Mr Jones has 20,000 to invest. He invests part at 6% and part at 7%, if hr earns 1,280 in interest after 1 year, how much did he invest at each rate.
why does methane have a low boiling pint?
If a fair quarter is flipped 3 times . What is the probability of getting exactly three heads? round to the neast thoudsands.
Venn Diagram: In a school all of the 120 pupils must choose at least one of Archery, Badminton or Cycling. 63 pupils choose archery 62 pupils choose badminton
why are quebec and ontario known as canadas economic heart