3.1 SQL queries

What are some key benefits of using SQL for data analytics projects? Select all that apply.

A. Manage huge amounts of data

B. Adaptable for multiple database programs

C. Insertable images and text formatting

D. Powerful data cleaning tools

A. Manage huge amounts of data

B. Adaptable for multiple database programs

D. Powerful data cleaning tools

Which SQL function cleans string variables by extracting a substring from a string variable?

A. LEN

B. LENGTH

C. SUBSTR

D. COUNTIF

C. SUBSTR

You are working with a database table that contains data about playlists, and you discover there are duplicate entries. What SQL clause will remove the duplicates from the playlist_id column?

A. SELECT ONLY playlist_id

B. SELECT DUPLICATE playlist_id

C. SELECT DISTINCT playlist id

D. SELECT REMOVE playlist_ id

C. SELECT DISTINCT playlist id

You are working with a database table that contains data about turtles. What SQL clause will return any turtle ages that are less than three digits long from the turtle_age column

A. LENGTH (turtle age) < 3

B. LENGTH turtle age > 3

C. LENGTH turtle_ age < 3

D. LENGTH (turtle_age) > 3

A. LENGTH (turtle age) < 3

You are working with a database table that contains data about cookbooks. What SQL clause will retrieve the first eight letters of each data point in the recipe_name column, then store the result in a new column called recipe_listing?

A. SUBSTR (recipe_name, 8) to recipe_listing

B. SUBSTR (recipe_name, 8) AS recipe_listing

C. SUBSTR (recipe_name, 1, 8) AS recipe_listing

D. SUBSTR (recipe name, 1, 8) new_recipe_listing

C. SUBSTR (recipe_name, 1, 8) AS recipe_listing