w3resource
SQL exercises

SQL: Find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last

SQL Basic Select Statement : Exercise-24 with Solution.

Write a SQL query to find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last.

Sample table: nobel_win

 

Sample Solution :

SELECT *
FROM nobel_win
WHERE year=1970 
ORDER BY
 CASE
    WHEN subject IN ('Economics','Chemistry') THEN 1
    ELSE 0
 END ASC,
 subject,
 winner;

Output:

SQL exercises

Query Visualization:

Duration:

Query visualization of Find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last - Duration

Rows:

Query visualization of Find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last - Rows

Cost:

Query visualization of Find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last - Cost

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL query to find all the details of the nobel winners for the subject not started with the letter 'P' and arranged the list as the most recent comes first, then by name in order.
Next: Write a SQL query to find all the products with a price between Rs.200 and Rs.600.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming