Register
Write query to get the max and min salary of job_id 101​
8.5k views
8 votes
Write query to get the max and min salary of job_id 101​

User Bpeikes
by
3.4k points

1 Answer

11 votes

Answer:

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

Step-by-step explanation:

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

User Mukul Goel
by
2.7k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

3.5m questions

4.5m answers

Other Questions

Assume you have created a mechanical arm that can hold a pen. The arm can perform the following tasks: • Lower the pen to a piece of paper. • Raise the pen from the paper. • Move the pen 1 inch along a
Does anyone have game design in connections
What do customers typically notice during virtual interactions?
Software that protects confidentiality by screening outgoing documents to identify and block transmission of sensitive information is called a)Digital Watermark b)Information Rights Management (IRM) c)None
PLS ANSWER ASAP!! Match the cloud computing service to its description. 1) infrastructure as a service 2) platform as a service 3) software as a service a) offers a virtual computing platform consisting
Link Copied!