Blog

Which type of volcano produced this rock? Tip: Think about what type of volcanoes produce this material and consider its location on the map (ie. if it is a pillow basalt in the middle of the ocean it is probably a mid ocean ridge volcano)

Look at the map where the sample is labeled (on the continent). What general direction is the plate moving at this location? Reminder: If it is a hot spot-fueled island chain, consider the direction of the chain. If it is at a boundary, think about the direction the plates are moving in relation to each other and then answer according to which plate the sample is on.

In the center of the largest continent, you find a very soft (soft enough to scratch with a fingernail), translucent mineral (sample 6).

Look at the map where the sample is labeled (on the continent). What general direction is the plate moving at this location? Reminder: If it is a hot spot-fueled island chain, consider the direction of the chain. If it is at a boundary, think about the direction the plates are moving in relation to each other and then answer according to which plate the sample is on.

Find the equation in slope – intercept form, , of the line shown in the graph below. Equation:

A hospital is reviewing patient data.  (Each row in their data represents a patient diagnosis during a hospital visit.)  While conducting this review, what would the following LAG function accomplish?

Common Table Expressions (CTEs)

How can a LEAD function be modified to access data from rows further away?

What is indicated by the use of ‘NULL’ in the results of the LAG and LEAD functions?

What is the primary purpose of a LAG function?