SQL Dump for Products, Sales and Customers JOIN Examples

Use this sample schema and data with the related JOIN tutorial. The dump keeps the original teaching dataset while using current integer declarations, InnoDB and utf8mb4 defaults.

CREATE TABLE IF NOT EXISTS `customers_v2` (
  `c_id` INT DEFAULT NULL,
  `customer` varchar(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `customers_v2`
--

INSERT INTO `customers_v2` (`c_id`, `customer`) VALUES
(1, 'Rabi'),
(2, 'Raju'),
(3, 'Alex'),
(4, 'Rani'),
(5, 'King'),
(7, 'Ronn'),
(8, 'Jem'),
(9, 'Tom');

-- --------------------------------------------------------

--
-- Table structure for table `products_v2`
--

CREATE TABLE IF NOT EXISTS `products_v2` (
  `p_id` INT DEFAULT NULL,
  `product` varchar(12) DEFAULT NULL,
  `price` INT DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_v2`
--

INSERT INTO `products_v2` (`p_id`, `product`, `price`) VALUES
(1, 'Hard Disk', 80),
(2, 'RAM', 90),
(3, 'Monitor', 75),
(4, 'CPU', 55),
(5, 'Keyboard', 20),
(6, 'Mouse', 10),
(7, 'Motherboard', 50),
(8, 'Power supply', 20);

-- --------------------------------------------------------

--
-- Table structure for table `sales_v2`
--

CREATE TABLE IF NOT EXISTS `sales_v2` (
  `sale_id` INT DEFAULT NULL,
  `c_id` INT DEFAULT NULL,
  `p_id` INT DEFAULT NULL,
  `product` varchar(7) DEFAULT NULL,
  `qty` INT DEFAULT NULL,
  `store` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sales_v2`
--

INSERT INTO `sales_v2` (`sale_id`, `c_id`, `p_id`, `product`, `qty`, `store`) VALUES
(1, 2, 3, 'Monitor', 2, 'ABC'),
(2, 2, 4, 'CPU', 1, 'DEF'),
(3, 1, 3, 'Monitor', 3, 'ABC'),
(4, 4, 2, 'RAM', 2, 'DEF'),
(5, 2, 3, 'Monitor', 3, 'ABC'),
(6, 3, 3, 'Monitor', 2, 'DEF'),
(7, 2, 2, 'RAM', 3, 'ABC'),
(8, 3, 2, 'RAM', 2, 'DEF'),
(9, 2, 3, 'Monitor', 2, 'ABC'),
(10, 10, 20, 'USB', 2, 'ABC'),
(11, 10, 21, 'pendriv', 1, 'DEF'),
(12, 11, 22, 'Cable', 3, 'DEF');

SQL Inner Join RIGHT JOIN
SQL

← Back to the related JOIN tutorial

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

SQL Dump: Products, Sales and Customers

Subhendu Mohapatra