SQL exercises | Scalar functions

Showing exercises 1-6 (out of 6)

Category: SQL
Topic: Scalar functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Use a scalar function to include each Dr Who's incarnation dates in a query.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Count the number of letters for an event using a scalar function.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Use an SQL function within a query to find out the part number of any Dr Who episode.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a function to take in any month number and return the month name.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Harder than average
Course: Advanced SQL
Exercise: Create all sorts of scalar functions in SQL to return info about Dr Who episodes from within a query.

Go to exercise ...

Category: SQL
Topic: Scalar functions
Level: Harder than average
Course: Advanced SQL
Exercise: Use a CASE statement to classify each event according to whether it is the top of its class or not.

Go to exercise ...

This page has 0 threads Add post