Pre-Requisite
Prior to starting this lesson you'll want to create a directory with the following files within it:
- Dockerfile
- practice.sql
- dog_data.csv
Ensure to add the following content to dog_data.csv:
id,name,breed,color,age
1,Bella,Labrador,Black,3
2,Max,Golden Retriever,Golden,5
3,Charlie,Poodle,White,2
4,Lucy,Bulldog,Brindle,4
5,Cooper,Beagle,Brown,6
6,Daisy,German Shepherd,Tan,7
7,Milo,Dachshund,Black,1
8,Luna,Husky,Gray,3
9,Rocky,Boxer,Fawn,5
10,Sadie,Australian Shepherd,Merle,4
11,Toby,Shih Tzu,White,8
12,Zoey,Corgi,Red,2
13,Bailey,Border Collie,Black,6
14,Bear,Rottweiler,Black,9
15,Chloe,Pug,Fawn,3
16,Leo,Chihuahua,Tan,1
17,Maggie,Great Dane,Blue,7
18,Oscar,Boston Terrier,Black,4
19,Penny,Mini Schnauzer,Gray,5
20,Jack,Jack Russell,White,6
21,Rosie,Yorkshire Terrier,Brown,2
22,Bentley,Labrador,Chocolate,8
23,Nala,Akita,White,4
24,Finn,Irish Setter,Red,5
25,Ruby,Weimaraner,Silver,3
26,Murphy,Old English Sheepdog,Gray,6
27,Lily,Maltese,White,9
28,Dexter,Doberman,Black,2
29,Olive,Whippet,Brindle,4
30,Henry,Basset Hound,Brown,7