Contribute to chamiSG/coderbyte-challenges development by creating an account on GitHub.

Jul 30, 2022 · SELECT FirstName, LastName, ReportsTo, Position, Age, CASE WHEN ReportsTo = 'Jenny Richards' THEN 'CEO' ELSE 'None' END AS BossTitle FROM maintable_WD9RV WHERE ReportsTo = 'Jenny Richards' …

Dec 9, 2016 · You'd be better off calculating age and ORDER BY age, then grouping then in another language. BirthdayDate . This will show at first the ones, whose age is > 35 years, after that - others. +1 for the IF combined with column ORDER BY. I still fail to see the usefulness of the result set. See similar questions with these tags.

To create a custom challenge on Coderbyte, navigate to your custom challenge library by clicking Customization and then Custom Challenges. Create SQL challenges. Under "Database" click Create. After adding metadata, select from one of your SQL tables and upload a solution query that generates an output table like in the example below.

Mar 18, 2021 · The rows should be ordered by Age. Your query should also add a column at the end with a title of Boss Title where the value is either None or CEO. Your output should look like the following table.

/* In this MySQL challenge, your query should return the rows from your table where LastName = Smith or FirstName = Robert and the rows should be sorted by Age in ascending order.

Jun 14, 2016 · SELECT pet_id, Name, [Type], Breed, Born, DATEDIFF(hour, Born, GETDATE())/8766 as 'Age' FROM pet WHERE Born BETWEEN '1999' AND '2001' ORDER BY DATEDIFF(hour, Born, GETDATE())/8766 DESC

Access our premium code compilers with any membership plan which will allow you to run your code and test cases faster. We are the only platform that calculates the runtime complexity of your code solutions, so you can see how your algorithms stack up against other users!

Sort rows into age ranges using date of birth. GitHub Gist: instantly share code, notes, and snippets.

Upload your own SQL challenge with a custom table, and run a query as the solution. Candidates must then write a query which matches the output table. Learn more here.