Download SQL DUMP of products sales and customers tables for demo of Query

products sales and customers SQL dump ( Sample )

CREATE TABLE IF NOT EXISTS `customers_v2` (
  `c_id` int(1) DEFAULT NULL,
  `customer` varchar(4) DEFAULT NULL
) ENGINE=MyISAM 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(1) DEFAULT NULL,
  `product` varchar(12) DEFAULT NULL,
  `price` int(2) DEFAULT NULL
) ENGINE=MyISAM 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(1) DEFAULT NULL,
  `c_id` int(1) DEFAULT NULL,
  `p_id` int(1) DEFAULT NULL,
  `product` varchar(7) DEFAULT NULL,
  `qty` int(1) DEFAULT NULL,
  `store` varchar(3) DEFAULT NULL
) ENGINE=MyISAM 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

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com

▼ More on Math functions in SQL

products sales and customers SQL dump ( Sample )

Subscribe