Learn
Courses
Career Tracks
Upcoming Courses
Certificates
Career Track Certificate
Course Certificate
Resources
All Resources
Course Notes
Templates
Infographics
Career Guides
Practice Exams
Blog
Success Stories
Pricing
Business
Team Plan
Live Trainings
Log In
Sign Up
Follow this topic
Share
Akash d shetty
Last answered:
06 Jan 2023
Posted on:
05 Jan 2023
0
I have solved it using CTE. I have arrived at the similar output.
in
SQL
/
SQL Subqueries nested in SELECT and FROM
1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:
06 Jan 2023
0
Submit an answer
Submit reply
related questions
Rhys Morgan
2
14
Rollback not reverting DB state after using INSERT INTO
Christopher Watts
0
6
Error Code: 1364. Field 'customer_id' doesn't have a default value
kfir ben galil
0
5
Resolved:
using the exists key word
Archisman Das
0
4
Resolved:
SQL Task- getting the names of all the managers who have an AVG salary of 85k+
Ali Mohamed Sedeek
1
3
I have done the assignment, where should I upload it ?!
Abdul Rehman
0
3
Resolved:
Why you are using different query editor for like new query for table creation of sales then new que
Meenakshi Akila P.S
0
3
using aliases in order by clause
Saeed Ehsanfar
0
3
Need clarification on why using e.emp_no < 10011 in the WHERE clause