Notifications

Clear all

Write a query to display all the town names which have summer temperatures more than jaipur

Last Post

Posts: 17

Rahul Updhyay

Topic starter

Aug 13, 2020 3:46 pm

(@rahul)

Active Member

Joined: 3 years ago

Write a query to display all the town names which have summer temperatures more than jaipur. the output should be sorted on the town name.

Guest-Payment-Resort-SQL-Query.jpg

This topic was modified 2 years ago 8 times by KV Kumar

Topic Tags

2 Replies

Posts: 18

Deepak Raj

Guest

Aug 22, 2020 4:07 am

(@Deepak Raj)

Active Member

Joined: 3 years ago

I hope the below will work. Any other solutions are welcome.

Select townname
from Resort
Inner join Town On Resort.resortID=Town.townID
AND Town.SummerTemp> (Select Town.SmmerTemp where Town.towname="JAIPUR")
Order By townname

This post was modified 2 years ago by KV Kumar

1 Reply

KV Kumar

Admin

(@vinodkrsetty)

Joined: 4 years ago

Eminent Member

Posts: 27

May 31, 2021 2:47 pm

Reply to

Deepak Raj

Consider the table called the town and it has two columns like town name and summer temperature then our query would be something as below.

Alias

TOWN NAME is TOWN_NAME
SUMMER TEMPERATURE is SUMMER_TEMP
TOWN is TWN

select TOWN_NAME from TOWN TWN
where TWN.SUMMER_TEMP>(select SUMMER_TEMP from TOWN where TOWN_NAME='JAIPUR')
order by TOWN_NAME;

This post was modified 2 years ago by KV Kumar