Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
2. Table grocery_store
CTEs with data modifying statements
Summary

Instruction

First let's see the database. In this part you will work with data related to grocery stores, its products, orders, and customers. Let's look at the tables we're going to work with.

The first table is the grocery_store. It gives basic identifying information for grocery stores.

Exercise

Select all information from the grocery_store table. This table consists of columns:

  • id – identifier of the grocery store,
  • name – name of the grocery store,
  • city - name of the city in which grocery store is located.