Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in PostgreSQL

Introduction
2. Grocery_store table
Using CTEs with data-modifying statements
Summary

Instruction

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

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

Exercise

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

  • id – A unique identifier of the grocery store.
  • name – The name of the grocery store.
  • city – The city in which grocery store is located.