\n",
" \n",
" product_id | \n",
" product_category_id | \n",
" product_name | \n",
" product_description | \n",
" product_price | \n",
" product_image | \n",
"
\n",
" \n",
" 1 | \n",
" 2 | \n",
" Quest Q64 10 FT. x 10 FT. Slant Leg Instant U | \n",
" | \n",
" 59.98 | \n",
" http://images.acmesports.sports/Quest+Q64+10+FT.+x+10+FT.+Slant+Leg+Instant+Up+Canopy | \n",
"
\n",
" \n",
" 2 | \n",
" 2 | \n",
" Under Armour Men's Highlight MC Football Clea | \n",
" | \n",
" 129.99 | \n",
" http://images.acmesports.sports/Under+Armour+Men%27s+Highlight+MC+Football+Cleat | \n",
"
\n",
" \n",
" 3 | \n",
" 2 | \n",
" Under Armour Men's Renegade D Mid Football Cl | \n",
" | \n",
" 89.99 | \n",
" http://images.acmesports.sports/Under+Armour+Men%27s+Renegade+D+Mid+Football+Cleat | \n",
"
\n",
" \n",
" 4 | \n",
" 2 | \n",
" Under Armour Men's Renegade D Mid Football Cl | \n",
" | \n",
" 89.99 | \n",
" http://images.acmesports.sports/Under+Armour+Men%27s+Renegade+D+Mid+Football+Cleat | \n",
"
\n",
" \n",
" 5 | \n",
" 2 | \n",
" Riddell Youth Revolution Speed Custom Footbal | \n",
" | \n",
" 199.99 | \n",
" http://images.acmesports.sports/Riddell+Youth+Revolution+Speed+Custom+Football+Helmet | \n",
"
\n",
" \n",
" 6 | \n",
" 2 | \n",
" Jordan Men's VI Retro TD Football Cleat | \n",
" | \n",
" 134.99 | \n",
" http://images.acmesports.sports/Jordan+Men%27s+VI+Retro+TD+Football+Cleat | \n",
"
\n",
" \n",
" 7 | \n",
" 2 | \n",
" Schutt Youth Recruit Hybrid Custom Football H | \n",
" | \n",
" 99.99 | \n",
" http://images.acmesports.sports/Schutt+Youth+Recruit+Hybrid+Custom+Football+Helmet+2014 | \n",
"
\n",
" \n",
" 8 | \n",
" 2 | \n",
" Nike Men's Vapor Carbon Elite TD Football Cle | \n",
" | \n",
" 129.99 | \n",
" http://images.acmesports.sports/Nike+Men%27s+Vapor+Carbon+Elite+TD+Football+Cleat | \n",
"
\n",
" \n",
" 9 | \n",
" 2 | \n",
" Nike Adult Vapor Jet 3.0 Receiver Gloves | \n",
" | \n",
" 50.0 | \n",
" http://images.acmesports.sports/Nike+Adult+Vapor+Jet+3.0+Receiver+Gloves | \n",
"
\n",
" \n",
" 10 | \n",
" 2 | \n",
" Under Armour Men's Highlight MC Football Clea | \n",
" | \n",
" 129.99 | \n",
" http://images.acmesports.sports/Under+Armour+Men%27s+Highlight+MC+Football+Cleat | \n",
"
\n",
"
"
],
"text/plain": [
"[(1, 2, 'Quest Q64 10 FT. x 10 FT. Slant Leg Instant U', '', 59.98, 'http://images.acmesports.sports/Quest+Q64+10+FT.+x+10+FT.+Slant+Leg+Instant+Up+Canopy'),\n",
" (2, 2, \"Under Armour Men's Highlight MC Football Clea\", '', 129.99, 'http://images.acmesports.sports/Under+Armour+Men%27s+Highlight+MC+Football+Cleat'),\n",
" (3, 2, \"Under Armour Men's Renegade D Mid Football Cl\", '', 89.99, 'http://images.acmesports.sports/Under+Armour+Men%27s+Renegade+D+Mid+Football+Cleat'),\n",
" (4, 2, \"Under Armour Men's Renegade D Mid Football Cl\", '', 89.99, 'http://images.acmesports.sports/Under+Armour+Men%27s+Renegade+D+Mid+Football+Cleat'),\n",
" (5, 2, 'Riddell Youth Revolution Speed Custom Footbal', '', 199.99, 'http://images.acmesports.sports/Riddell+Youth+Revolution+Speed+Custom+Football+Helmet'),\n",
" (6, 2, \"Jordan Men's VI Retro TD Football Cleat\", '', 134.99, 'http://images.acmesports.sports/Jordan+Men%27s+VI+Retro+TD+Football+Cleat'),\n",
" (7, 2, 'Schutt Youth Recruit Hybrid Custom Football H', '', 99.99, 'http://images.acmesports.sports/Schutt+Youth+Recruit+Hybrid+Custom+Football+Helmet+2014'),\n",
" (8, 2, \"Nike Men's Vapor Carbon Elite TD Football Cle\", '', 129.99, 'http://images.acmesports.sports/Nike+Men%27s+Vapor+Carbon+Elite+TD+Football+Cleat'),\n",
" (9, 2, 'Nike Adult Vapor Jet 3.0 Receiver Gloves', '', 50.0, 'http://images.acmesports.sports/Nike+Adult+Vapor+Jet+3.0+Receiver+Gloves'),\n",
" (10, 2, \"Under Armour Men's Highlight MC Football Clea\", '', 129.99, 'http://images.acmesports.sports/Under+Armour+Men%27s+Highlight+MC+Football+Cleat')]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%sql SELECT * FROM products LIMIT 10"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * postgresql://itversity_retail_user:***@localhost:5432/itversity_retail_db\n",
"1 rows affected.\n"
]
},
{
"data": {
"text/html": [
"