Spring Time Software Interview Questions: Given two tables of genre and track . Write an sql query to

Asked inSpring Time Software,Software Engineer

Given two tables of genre and track . Write an sql query to count number of tracks with genre 'heavy metal'.

CodingNinjas

author

It was a SQL question . I had done it using join with condition WHERE Clause.

Help your peers!

Add answer anonymously...

Top Spring Time Software Software Engineer interview questions & answers

Q1. Scramble StringYou are given an integer ‘N’ and two strings ‘S’ and 'R' each having size = ‘N’. You can scramble the str...read more

View answers (2)

Q2. Replace 0'sGiven a matrix where every element is either 1 or 0(zero), replace 0 with 1 if surrounded by 1. A 0 (or a set...read more

View answer (1)

Q3. Write an SQL query to print details of the Workers who are also Managers.

View answer (1)

Spring Time Software

Discover recent interview experiences

View all

Interview Tips & Stories

Ace your next interview with expert advice and inspiring stories

Explore community

Popular interview questions of Software Engineer

Q1. Bridge and torch problem : Four people come to a river in the nig...read more

asked in

Qualcomm

View answers (170)

Q2. In a dark room,there is a box of 18 white and 5 black gloves. You...read more

asked in

Capgemini

View answers (521)

Q3. Find DuplicateYou have been given an integer array/list(ARR) of s...read more

asked in

Spring Time Software Interview Questions

Spring Time Software Software Engineer Interview Questions

Stay ahead in your career. Get AmbitionBox app

Helping over 1 Crore job seekers every month in choosing their right fit company

65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

65 Lakh+

Reviews

4 Lakh+

Interviews

4 Crore+

Salaries

1 Crore+

Users/Month

Contribute

Contribute to help millions

Reviews

Get AmbitionBox app