Topfolio
Career TracksJob Hunt TrackerMicro Free CoursesTask CoursesPracticeInterview PracticeWork ExperienceProjects
Career TrackBlog
Support
Dashboard
Career TracksMicro Free CoursesTask Courses
SQL & Python
Interview Prep
Job Hunt TrackerWork ExperienceProjectsResume Feedback
CertificatesMy OrdersRefer & Earn
Join Community

Navigation

Dashboard
Learn
Career TracksMicro Free CoursesTask Courses
Practice
SQL & PythonInterview Prep
Career
Job Hunt TrackerWork ExperienceProjectsResume Feedback
My Stuff
CertificatesMy OrdersRefer & Earn
Join Community
Topfolio

Learn data analytics online. Real skills, real projects, real community.

courses

  • Career Tracks
  • Work Experience
  • Best Data Analyst Course in India
  • SQL Fundamentals
  • SQL Advanced
  • Python for Data
  • Micro Free Courses

practice

  • SQL Fundamentals Interview Test
  • SQL Advanced Coding Test
  • All Practice Tests

resources

  • How to Become a Data Analyst
  • SQL Interview Questions
  • Data Analyst Salary Guide
  • Free Datasets for Practice
  • SQL vs NoSQL Guide
  • Data Analyst vs Data Engineer vs Data Scientist

employers

  • Enterprise Screening
  • AI Proctoring Demo
  • Volume Pricing
  • Employer Portal

company

  • About
  • Terms
© 2026 Topfolio. All rights reserved.Made with ❤️ for aspiring analysts
Topfolio
Career TracksJob Hunt TrackerMicro Free CoursesTask CoursesPracticeInterview PracticeWork ExperienceProjects
Career TrackBlog
Support
Dashboard
Career TracksMicro Free CoursesTask Courses
SQL & Python
Interview Prep
Job Hunt TrackerWork ExperienceProjectsResume Feedback
CertificatesMy OrdersRefer & Earn
Join Community

Navigation

Dashboard
Learn
Career TracksMicro Free CoursesTask Courses
Practice
SQL & PythonInterview Prep
Career
Job Hunt TrackerWork ExperienceProjectsResume Feedback
My Stuff
CertificatesMy OrdersRefer & Earn
Join Community

OR Conditions: Rock or Metal Tracks

intermediate~4 min15 pts
📊 View Insights

Problem

Find all tracks that are either Rock OR Metal genre. Use OR to match either condition.

Write a query to find tracks in Rock or Metal genres.

Schema: Track

ColumnType
TrackIdINTEGER (Primary Key)
NameTEXT
AlbumIdINTEGER (Foreign Key → Album.AlbumId)
MediaTypeIdINTEGER (Foreign Key)
GenreIdINTEGER (Foreign Key → Genre.GenreId)
ComposerTEXT
MillisecondsINTEGER
BytesINTEGER
UnitPriceNUMERIC(10,2)

Schema: Genre

ColumnType
GenreIdINTEGER (Primary Key)
NameTEXT

Requirements:

  • Join Track with Genre
  • Filter for Genre.Name = 'Rock' OR Genre.Name = 'Metal'
  • Return TrackName, GenreName
  • Order by TrackId ascending
  • Limit to 20 rows
WHEREORJOIN
📊
📊 View Question Telemetry & Insights
Failure rate, silent bug autopsy & optimal query construction
Inspect →

Master SQL & Data Analytics

Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.

Explore the 12-Week Data Analyst Career Track

Related questions

  • Find US Customersbeginner
  • Premium Priced Tracksbeginner
  • Search Artists by Name Patternbeginner
  • Customers from Multiple Countriesbeginner
  • Albums with Artist Namesintermediate
  • Tracks with Genre Namesintermediate
  • Customer Purchase Historyintermediate
  • Track Count by Genreintermediate
SQL Editor

Run your code to see the result here.

Topfolio

Learn data analytics online. Real skills, real projects, real community.

courses

  • Career Tracks
  • Work Experience
  • Best Data Analyst Course in India
  • SQL Fundamentals
  • SQL Advanced
  • Python for Data
  • Micro Free Courses

practice

  • SQL Fundamentals Interview Test
  • SQL Advanced Coding Test
  • All Practice Tests

resources

  • How to Become a Data Analyst
  • SQL Interview Questions
  • Data Analyst Salary Guide
  • Free Datasets for Practice
  • SQL vs NoSQL Guide
  • Data Analyst vs Data Engineer vs Data Scientist

employers

  • Enterprise Screening
  • AI Proctoring Demo
  • Volume Pricing
  • Employer Portal

company

  • About
  • Terms
© 2026 Topfolio. All rights reserved.Made with ❤️ for aspiring analysts