using count · csH sql walk routes

csH sql walk routes

Explore

basic aggregate functions

Using the count() function

Create and test SQL code to produce solutions to these requirements.

Try a simple version first, like: display all the walks. Then introduce count(), then add an alias

select * from walk

select count(*) from walk

select count(*) as "Number of walks" from walk

save your working code in application express

How many walks are there?

How many coastal routes are there?

How many walks were in the rain?

How many walks followed route 2?

⁠

more aggregate functions

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.