Table: gps_nav_data
Columns: subframe
page
name
word
bits

Question: What is the average word count with crs and subframes lesser than 2?
SQL: SELECT AVG("word") FROM gps_nav_data WHERE "name" = 'crs' AND "subframe" < 2

Question: What is the page count and word count greater than 5 with Bits of 18–22?
SQL: SELECT "page" FROM gps_nav_data WHERE "word" > 5 AND "bits" = '18–22'

Question: What is the total subframe count with Bits of 18–22?
SQL: SELECT SUM("subframe") FROM gps_nav_data WHERE "bits" = '18–22'