Problem: How many payment transactions were greater than $5.00?
--Return the number of payment transactions were greater than $5.00
SELECT COUNT(amount)
FROM payment
WHERE amount > 5;## count
## 1 3618Problem: How many actors have a first name that starts with the letter P
--Return the number of actors that have a first name which starts with the letter P
SELECT COUNT(actor)
FROM actor
WHERE first_name LIKE 'P%';## count
## 1 5Problem: How many unique districts are our customers from?
--Return the number of unique districts that are our customers from
SELECT COUNT(DISTINCT(district))
FROM address;## count
## 1 378Problem: Retrieve the list of names for those distinct districts from the previous question.
--Return the names of unique districts that are our customers from
SELECT DISTINCT district
FROM address;## district
## 1 Aden
## 2 Eastern Visayas
## 3 Vaduz
## 4 Tokat
## 5 Anzotegui
## 6 Saint-Denis
## 7 Chollanam
## 8 Chihuahua
## 9 Nyanza
## 10 Changhwa
## 11 Tokyo-to
## 12 Santa F
## 13 Denizli
## 14 Noord-Brabant
## 15 Hubei
## 16 Zulia
## 17 Paran
## 18 Mwanza
## 19 Nova Scotia
## 20 Caraga
## 21 Batman
## 22 Assam
## 23 Hanoi
## 24 Andhra Pradesh
## 25 Battambang
## 26 Washington
## 27 Madhya Pradesh
## 28 Gauteng
## 29 Adana
## 30 Basel-Stadt
## 31 Par
## 32 Risaralda
## 33 Jiangxi
## 34 West Bengali
## 35 Tennessee
## 36 Copperbelt
## 37 Krim
## 38 Arecibo
## 39 Guangdong
## 40 Shiga
## 41 Santa Catarina
## 42 Vojvodina
## 43 Maharashtra
## 44 Northern Mindanao
## 45 Rio Grande do Sul
## 46 Ynlin
## 47 Scotland
## 48 Edo & Delta
## 49 Central Visayas
## 50 al-Manama
## 51 North West
## 52 Kaohsiung
## 53 Baja California Sur
## 54 Chuquisaca
## 55 Nampula
## 56 Ibaragi
## 57 Carabobo
## 58 Provence-Alpes-Cte
## 59 Mxico
## 60 Smolensk
## 61 Qaraghandy
## 62 Funafuti
## 63 Haryana
## 64 Saarland
## 65 al-Qadarif
## 66 Tabora
## 67 Pyongyang-si
## 68 Tamil Nadu
## 69 Steiermark
## 70 Baijeri
## 71 Adygea
## 72 Yamaguchi
## 73 Georgia
## 74 Northern Cape
## 75 Baskimaa
## 76 Santiago
## 77 Tucumn
## 78 Lilongwe
## 79 Sisilia
## 80 Markazi
## 81 Hamilton
## 82 Liaoning
## 83 Chisinau
## 84 Sofala
## 85 Tutuila
## 86 Distrito Federal
## 87 Nantou
## 88 Bukarest
## 89 West Greece
## 90 Miyazaki
## 91 Hawalli
## 92 Rio de Janeiro
## 93 Central Mindanao
## 94 East Java
## 95 British Colombia
## 96 Botosani
## 97 Bern
## 98 Northern
## 99 Nordrhein-Westfalen
## 100 Kerman
## 101 Balikesir
## 102 Kitaa
## 103 Tamaulipas
## 104 Gujarat
## 105 Piemonte
## 106 Nothwest Border Prov
## 107 Kurgan
## 108 Kursk
## 109 Salzburg
## 110 Kaduna
## 111 Hodeida
## 112 Osmaniye
## 113 Ohio
## 114 Asuncin
## 115 Kerala
## 116 Midi-Pyrnes
## 117 Batna
## 118 Ponce
## 119 al-Sharqiya
## 120 Lombardia
## 121 Sichuan
## 122 East Kasai
## 123 Nagasaki
## 124 Perak
## 125 National Capital Reg
## 126 Volgograd
## 127 Bretagne
## 128 Skne ln
## 129 England
## 130 Bauchi & Gombe
## 131 Western Cape
## 132 Xinxiang
## 133 Mie
## 134 Gifu
## 135 Nakhon Sawan
## 136 Kanagawa
## 137 Southern Mindanao
## 138 New Hampshire
## 139 Haskovo
## 140 Sanaa
## 141 Minsk
## 142 Brunei and Muara
## 143 Tete
## 144 Miranda
## 145 Oyo & Osun
## 146 Kyonggi
## 147 Skikda
## 148 Oriental
## 149 St George
## 150 Kowloon and New Kowl
## 151 Kujawsko-Pomorskie
## 152 Florida
## 153 Slaskie
## 154 Baja California
## 155 Wielkopolskie
## 156 Inner Mongolia
## 157 Khanh Hoa
## 158 Krasnojarsk
## 159 Pohjois-Pohjanmaa
## 160 Severn Morava
## 161 Punjab
## 162 Sumqayit
## 163 Gaziantep
## 164 St Thomas
## 165 Sumy
## 166 Massachusetts
## 167 Gansu
## 168 Osaka
## 169 Kabol
## 170 Haiphong
## 171 Cheju
## 172 Illinois
## 173 Coahuila de Zaragoza
## 174 Virginia
## 175 Chiayi
## 176 Minas Gerais
## 177 Gurico
## 178 Hebei
## 179 Shaba
## 180 Buenos Aires
## 181 Asturia
## 182 KwaZulu-Natal
## 183 Mandalay
## 184 Hmelnytskyi
## 185 Fukushima
## 186 Taipei
## 187 Baden-Wrttemberg
## 188 Saitama
## 189 Tadla-Azilal
## 190 Galicia
## 191 Gelderland
## 192 al-Qalyubiya
## 193 Attika
## 194 Irkutsk
## 195 Gois
## 196 Zufar
## 197 Nonthaburi
## 198 Anhalt Sachsen
## 199 Tongatapu
## 200 Friuli-Venezia Giuli
## 201 Pietari
## 202 Namibe
## 203 Okinawa
## 204 Free State
## 205 Central Java
## 206 Tel Aviv
## 207 Jalisco
## 208 Oaxaca
## 209 Fejr
## 210 Sumatera Selatan
## 211 Kwara & Kogi
## 212 Puebla
## 213 Cear
## 214 Heilongjiang
## 215 Fujian
## 216 Sokoto & Kebbi & Zam
## 217 Addis Abeba
## 218 Nebraska
## 219 Sousse
## 220 Nord-Ouest
## 221 Stavropol
## 222 Mahajanga
## 223 Esprito Santo
## 224 Vaud
## 225 OHiggins
## 226 Tartumaa
## 227 Mazowieckie
## 228 Kaliningrad
## 229 Colorado
## 230 Abu Dhabi
## 231 Bchar
## 232 Vilna
## 233 Eskisehir
## 234 West Java
## 235 Baki
## 236 Mekka
## 237 Taka-Karpatia
## 238 Ha Darom
## 239 Valle
## 240 Ahal
## 241 Antofagasta
## 242 Masqat
## 243 Usak
## 244 Shandong
## 245
## 246 Callao
## 247 Henan
## 248 Ninawa
## 249 Benguela
## 250 Kilis
## 251 QLD
## 252 Michigan
## 253 Dhaka
## 254 Kalimantan Barat
## 255 Chaharmahal va Bakht
## 256 Central Serbia
## 257 Istanbul
## 258 Nam Ha
## 259 Sivas
## 260 La Paz
## 261 Chari-Baguirmi
## 262 Alberta
## 263 Chimborazo
## 264 Hiroshima
## 265 California
## 266 La Romana
## 267 Komi
## 268 Jiangsu
## 269 Jakarta Raya
## 270 Kyongsangbuk
## 271 Ziguinchor
## 272 Tabuk
## 273 Sinaloa
## 274 Sharja
## 275 Bratislava
## 276 Cayenne
## 277 Songkhla
## 278 Yerevan
## 279 Uttar Pradesh
## 280 Okayama
## 281 Ondo & Ekiti
## 282 Utrecht
## 283 Bursa
## 284 Taizz
## 285 North Austria
## 286 Hidalgo
## 287 Jharkhand
## 288 Rajasthan
## 289 Ningxia
## 290 Puerto Plata
## 291 Missouri
## 292 Loja
## 293 al-Daqahliya
## 294 Karnataka
## 295 Boyac
## 296 Tuvassia
## 297 Pays de la Loire
## 298 Liepaja
## 299 Nizni Novgorod
## 300 Moskova
## 301 Coquimbo
## 302 Tianjin
## 303 Khartum
## 304 Guerrero
## 305 Drenthe
## 306 Ivanovo
## 307 Shimane
## 308 Michoacn de Ocampo
## 309 Kirov
## 310 Piura
## 311 Streymoyar
## 312 Sarawak
## 313 East Azerbaidzan
## 314 So Paulo
## 315 Huanuco
## 316 Hainan
## 317 Zhejiang
## 318 Mogiljov
## 319 Aceh
## 320 Kermanshah
## 321 Apulia
## 322 Campeche
## 323 Pernambuco
## 324 Central
## 325 Moscow (City)
## 326 Dolnoslaskie
## 327 Qina
## 328 Shanxi
## 329 Chiba
## 330 Ruse
## 331 Ishikawa
## 332 Gumma
## 333 Guanajuato
## 334 North Carolina
## 335 Tahiti
## 336 Manab
## 337 Cagayan Valley
## 338 Nagano
## 339 Kedah
## 340 Banjul
## 341 Hunan
## 342 Roraima
## 343 Lima
## 344 Qubec
## 345 Sagaing
## 346 Bihar
## 347 Rabat-Sal-Zammour-Z
## 348 Crdoba
## 349 Pavlodar
## 350 Zanzibar West
## 351 Toscana
## 352 Lipetsk
## 353 Jaroslavl
## 354 Ontario
## 355 Caquet
## 356 Lubelskie
## 357 Asir
## 358 Sawhaj
## 359 Alto Paran
## 360 Kang-won
## 361 Southern Tagalog
## 362 Sucre
## 363 Jilin
## 364 Morelos
## 365 Sulawesi Utara
## 366 Phnom Penh
## 367 Kalmykia
## 368 Tatarstan
## 369 Esfahan
## 370 Centre
## 371 Daugavpils
## 372 Central Luzon
## 373 Texas
## 374 Rostov-na-Donu
## 375 Sind
## 376 Nghe An
## 377 Ktahya
## 378 VeracruzProblem: How many films have a rating of R and a replacement cost between $5 and $15?
--Return the number of films have a rating of R and a replacement cost between $5 and $15
SELECT COUNT(*)
FROM film
WHERE rating = 'R' AND replacement_cost BETWEEN 5 AND 15;## count
## 1 52Problem: How many films have the word Truman somewhere in the title?
--Return the number of films have the word Truman somewhere in the title
SELECT COUNT(*)
FROM film
WHERE title LIKE '%Truman%';## count
## 1 5