WK4 More SQL Filters: Filter dates & numbers

Question 1

3 Data types

Answer 1

the three common data types that you will find in databases: string, numeric, and date and time.

Question 2

String Data

Answer 2

String data is data consisting of an ordered sequence of characters. These characters could be numbers, letters, or symbols. For example, you’ll encounter string data in user names, such as a user name: analyst10

Question 3

Numeric Data

Answer 3

Numeric data is data consisting of numbers, such as a count of log-in attempts. Unlike strings, mathematical operations can be used on numeric data, like multiplication or addition.

Question 4

Date and Time Data

Answer 4

Date and time data refers to data representing a date and/or time.

An important thing to note is that when we filter for strings, dates, and times, we use quotation marks to specify what we’re looking for. However, for numbers, we don’t use quotation marks.