File: /home/mfarooq33/Documents/SQL Queries Page 1 of 10

SELECT user, COUNT(*)

FROM hacker_news
WHERE url LIKE ='%watch?v=dQw4w9WgXcQ%'
GROUP BY 1
ORDER BY 2 DESC;

SELECT CASE
WHEN url LIKE '%github.com%' THEN 'GitHub'
WHEN url LIKE '%medium.com%' THEN 'Medium'
WHEN url LIKE '%nytimes.com% THEN 'New York Times'
END AS 'Source'
FROM hacker_news;

SELECT CASE
WHEN url LIKE '%github.com%' THEN 'GitHub'
WHEN url LIKE '%medium.com%' THEN 'Medium'
WHEN url LIKE '%nytimes.com% THEN 'New York Times'
END AS 'Source'
COUNT(*)
FROM hacker_news
GROUP BY 1;

SELECT timestamp, strftime('%H', timestamp)

FROM hacker_news
GROUP BY 1
LIMIT 10;

SELECT title, medium, date

FROM met
ORDER BY date DESC;

SELECT a.ord_num,b.cust_name,a.cust_code,
c.agent_code,b.cust_city
FROM agents c,customer b,orders a
WHERE b.cust_city=c.working_area
AND a.cust_code=b.cust_code
AND a.agent_code=c.agent_code;

SELECT o.order_id, o.subscription_id, s.subscription_id, s.description

FROM orders o, subscription s
WHERE o.subscription_id = s.subscription_id AND
WHERE o.order_id ='1';

CREATE TABLE "AGENTS"

(
"AGENT_CODE" CHAR(6) NOT NULL PRIMARY KEY,
"AGENT_NAME" CHAR(40),
"WORKING_AREA" CHAR(35),
"COMMISSION" NUMBER(10,2),
"PHONE_NO" CHAR(15),
"COUNTRY" VARCHAR2(25)
);

INSERT INTO AGENTS VALUES ('A007', 'Ramasundar', 'Bangalore', '0.15',

'077-25814763', '');
INSERT INTO AGENTS VALUES ('A003', 'Alex ', 'London', '0.13', '075-12458969', '');
INSERT INTO AGENTS VALUES ('A008', 'Alford', 'New York', '0.12', '044-25874365',
'');
INSERT INTO AGENTS VALUES ('A011', 'Ravi Kumar', 'Bangalore', '0.15',
'077-45625874', '');
INSERT INTO AGENTS VALUES ('A010', 'Santakumar', 'Chennai', '0.14',
'007-22388644', '');
INSERT INTO AGENTS VALUES ('A012', 'Lucida', 'San Jose', '0.12', '044-52981425',
'');
INSERT INTO AGENTS VALUES ('A005', 'Anderson', 'Brisban', '0.13', '045-21447739',
File: /home/mfarooq33/Documents/SQL Queries Page 2 of 10

'');
INSERT INTO AGENTS VALUES ('A001', 'Subbarao', 'Bangalore', '0.14',
'077-12346674', '');
INSERT INTO AGENTS VALUES ('A002', 'Mukesh', 'Mumbai', '0.11', '029-12358964', '');
INSERT INTO AGENTS VALUES ('A006', 'McDen', 'London', '0.15', '078-22255588', '');
INSERT INTO AGENTS VALUES ('A004', 'Ivan', 'Torento', '0.15', '008-22544166', '');
INSERT INTO AGENTS VALUES ('A009', 'Benjamin', 'Hampshair', '0.11',
'008-22536178', '');

CREATE TABLE "CUSTOMER"

( "CUST_CODE" VARCHAR2(6) NOT NULL PRIMARY KEY,
"CUST_NAME" VARCHAR2(40) NOT NULL,
"CUST_CITY" CHAR(35),
"WORKING_AREA" VARCHAR2(35) NOT NULL,
"CUST_COUNTRY" VARCHAR2(20) NOT NULL,
"GRADE" NUMBER,
"OPENING_AMT" NUMBER(12,2) NOT NULL,
"RECEIVE_AMT" NUMBER(12,2) NOT NULL,
"PAYMENT_AMT" NUMBER(12,2) NOT NULL,
"OUTSTANDING_AMT" NUMBER(12,2) NOT NULL,
"PHONE_NO" VARCHAR2(17) NOT NULL,
"AGENT_CODE" CHAR(6) NOT NULL REFERENCES AGENTS
);

INSERT INTO CUSTOMER VALUES ('C00013', 'Holmes', 'London', 'London', 'UK', '2',
'6000.00', '5000.00', '7000.00', '4000.00', 'BBBBBBB', 'A003');
INSERT INTO CUSTOMER VALUES ('C00001', 'Micheal', 'New York', 'New York', 'USA',
'2', '3000.00', '5000.00', '2000.00', '6000.00', 'CCCCCCC', 'A008');
INSERT INTO CUSTOMER VALUES ('C00020', 'Albert', 'New York', 'New York', 'USA',
'3', '5000.00', '7000.00', '6000.00', '6000.00', 'BBBBSBB', 'A008');
INSERT INTO CUSTOMER VALUES ('C00025', 'Ravindran', 'Bangalore', 'Bangalore',
'India', '2', '5000.00', '7000.00', '4000.00', '8000.00', 'AVAVAVA', 'A011');
INSERT INTO CUSTOMER VALUES ('C00024', 'Cook', 'London', 'London', 'UK', '2',
'4000.00', '9000.00', '7000.00', '6000.00', 'FSDDSDF', 'A006');
INSERT INTO CUSTOMER VALUES ('C00015', 'Stuart', 'London', 'London', 'UK', '1',
'6000.00', '8000.00', '3000.00', '11000.00', 'GFSGERS', 'A003');
INSERT INTO CUSTOMER VALUES ('C00002', 'Bolt', 'New York', 'New York', 'USA', '3',
'5000.00', '7000.00', '9000.00', '3000.00', 'DDNRDRH', 'A008');
INSERT INTO CUSTOMER VALUES ('C00018', 'Fleming', 'Brisban', 'Brisban',
'Australia', '2', '7000.00', '7000.00', '9000.00', '5000.00', 'NHBGVFC', 'A005');
INSERT INTO CUSTOMER VALUES ('C00021', 'Jacks', 'Brisban', 'Brisban', 'Australia',
'1', '7000.00', '7000.00', '7000.00', '7000.00', 'WERTGDF', 'A005');
INSERT INTO CUSTOMER VALUES ('C00019', 'Yearannaidu', 'Chennai', 'Chennai',
'India', '1', '8000.00', '7000.00', '7000.00', '8000.00', 'ZZZZBFV', 'A010');
INSERT INTO CUSTOMER VALUES ('C00005', 'Sasikant', 'Mumbai', 'Mumbai', 'India',
'1', '7000.00', '11000.00', '7000.00', '11000.00', '147-25896312', 'A002');
INSERT INTO CUSTOMER VALUES ('C00007', 'Ramanathan', 'Chennai', 'Chennai',
'India', '1', '7000.00', '11000.00', '9000.00', '9000.00', 'GHRDWSD', 'A010');
INSERT INTO CUSTOMER VALUES ('C00022', 'Avinash', 'Mumbai', 'Mumbai', 'India',
'2', '7000.00', '11000.00', '9000.00', '9000.00', '113-12345678','A002');
INSERT INTO CUSTOMER VALUES ('C00004', 'Winston', 'Brisban', 'Brisban',
'Australia', '1', '5000.00', '8000.00', '7000.00', '6000.00', 'AAAAAAA', 'A005');
INSERT INTO CUSTOMER VALUES ('C00023', 'Karl', 'London', 'London', 'UK', '0',
'4000.00', '6000.00', '7000.00', '3000.00', 'AAAABAA', 'A006');
INSERT INTO CUSTOMER VALUES ('C00006', 'Shilton', 'Torento', 'Torento', 'Canada',
'1', '10000.00', '7000.00', '6000.00', '11000.00', 'DDDDDDD', 'A004');
INSERT INTO CUSTOMER VALUES ('C00010', 'Charles', 'Hampshair', 'Hampshair', 'UK',
'3', '6000.00', '4000.00', '5000.00', '5000.00', 'MMMMMMM', 'A009');
INSERT INTO CUSTOMER VALUES ('C00017', 'Srinivas', 'Bangalore', 'Bangalore',
'India', '2', '8000.00', '4000.00', '3000.00', '9000.00', 'AAAAAAB', 'A007');
INSERT INTO CUSTOMER VALUES ('C00012', 'Steven', 'San Jose', 'San Jose', 'USA',
'1', '5000.00', '7000.00', '9000.00', '3000.00', 'KRFYGJK', 'A012');
INSERT INTO CUSTOMER VALUES ('C00008', 'Karolina', 'Torento', 'Torento', 'Canada',
'1', '7000.00', '7000.00', '9000.00', '5000.00', 'HJKORED', 'A004');
INSERT INTO CUSTOMER VALUES ('C00003', 'Martin', 'Torento', 'Torento', 'Canada',
'2', '8000.00', '7000.00', '7000.00', '8000.00', 'MJYURFD', 'A004');
File: /home/mfarooq33/Documents/SQL Queries Page 3 of 10

INSERT INTO CUSTOMER VALUES ('C00009', 'Ramesh', 'Mumbai', 'Mumbai', 'India', '3',
'8000.00', '7000.00', '3000.00', '12000.00', 'Phone No', 'A002');
INSERT INTO CUSTOMER VALUES ('C00014', 'Rangarappa', 'Bangalore', 'Bangalore',
'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'AAAATGF', 'A001');
INSERT INTO CUSTOMER VALUES ('C00016', 'Venkatpati', 'Bangalore', 'Bangalore',
'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'JRTVFDD', 'A007');
INSERT INTO CUSTOMER VALUES ('C00011', 'Sundariya', 'Chennai', 'Chennai', 'India',
'3', '7000.00', '11000.00', '7000.00', '11000.00', 'PPHGRTS', 'A010');

CREATE TABLE "ORDERS"

(
"ORD_NUM" NUMBER(6,0) NOT NULL PRIMARY KEY,
"ORD_AMOUNT" NUMBER(12,2) NOT NULL,
"ADVANCE_AMOUNT" NUMBER(12,2) NOT NULL,
"ORD_DATE" DATE NOT NULL,
"CUST_CODE" VARCHAR2(6) NOT NULL REFERENCES CUSTOMER,
"AGENT_CODE" CHAR(6) NOT NULL REFERENCES AGENTS,
"ORD_DESCRIPTION" VARCHAR2(60) NOT NULL
);

INSERT INTO ORDERS VALUES('200100', '1000.00', '600.00', '08/01/2008', 'C00013',

'A003', 'SOD');
INSERT INTO ORDERS VALUES('200110', '3000.00', '500.00', '04/15/2008', 'C00019',
'A010', 'SOD');
INSERT INTO ORDERS VALUES('200107', '4500.00', '900.00', '08/30/2008', 'C00007',
'A010', 'SOD');
INSERT INTO ORDERS VALUES('200112', '2000.00', '400.00', '05/30/2008', 'C00016',
'A007', 'SOD');
INSERT INTO ORDERS VALUES('200113', '4000.00', '600.00', '06/10/2008', 'C00022',
'A002', 'SOD');
INSERT INTO ORDERS VALUES('200102', '2000.00', '300.00', '05/25/2008', 'C00012',
'A012', 'SOD');
INSERT INTO ORDERS VALUES('200114', '3500.00', '2000.00', '08/15/2008', 'C00002',
'A008', 'SOD');
INSERT INTO ORDERS VALUES('200122', '2500.00', '400.00', '09/16/2008', 'C00003',
'A004', 'SOD');
INSERT INTO ORDERS VALUES('200118', '500.00', '100.00', '07/20/2008', 'C00023',
'A006', 'SOD');
INSERT INTO ORDERS VALUES('200119', '4000.00', '700.00', '09/16/2008', 'C00007',
'A010', 'SOD');
INSERT INTO ORDERS VALUES('200121', '1500.00', '600.00', '09/23/2008', 'C00008',
'A004', 'SOD');
INSERT INTO ORDERS VALUES('200130', '2500.00', '400.00', '07/30/2008', 'C00025',
'A011', 'SOD');
INSERT INTO ORDERS VALUES('200134', '4200.00', '1800.00', '09/25/2008', 'C00004',
'A005', 'SOD');
INSERT INTO ORDERS VALUES('200108', '4000.00', '600.00', '02/15/2008', 'C00008',
'A004', 'SOD');
INSERT INTO ORDERS VALUES('200103', '1500.00', '700.00', '05/15/2008', 'C00021',
'A005', 'SOD');
INSERT INTO ORDERS VALUES('200105', '2500.00', '500.00', '07/18/2008', 'C00025',
'A011', 'SOD');
INSERT INTO ORDERS VALUES('200109', '3500.00', '800.00', '07/30/2008', 'C00011',
'A010', 'SOD');
INSERT INTO ORDERS VALUES('200101', '3000.00', '1000.00', '07/15/2008', 'C00001',
'A008', 'SOD');
INSERT INTO ORDERS VALUES('200111', '1000.00', '300.00', '07/10/2008', 'C00020',
'A008', 'SOD');
INSERT INTO ORDERS VALUES('200104', '1500.00', '500.00', '03/13/2008', 'C00006',
'A004', 'SOD');
INSERT INTO ORDERS VALUES('200106', '2500.00', '700.00', '04/20/2008', 'C00005',
'A002', 'SOD');
INSERT INTO ORDERS VALUES('200125', '2000.00', '600.00', '10/10/2008', 'C00018',
'A005', 'SOD');
INSERT INTO ORDERS VALUES('200117', '800.00', '200.00', '10/20/2008', 'C00014',
'A001', 'SOD');
File: /home/mfarooq33/Documents/SQL Queries Page 4 of 10

INSERT INTO ORDERS VALUES('200123', '500.00', '100.00', '09/16/2008', 'C00022',

'A002', 'SOD');
INSERT INTO ORDERS VALUES('200120', '500.00', '100.00', '07/20/2008', 'C00009',
'A002', 'SOD');
INSERT INTO ORDERS VALUES('200116', '500.00', '100.00', '07/13/2008', 'C00010',
'A009', 'SOD');
INSERT INTO ORDERS VALUES('200124', '500.00', '100.00', '06/20/2008', 'C00017',
'A007', 'SOD');
INSERT INTO ORDERS VALUES('200126', '500.00', '100.00', '06/24/2008', 'C00022',
'A002', 'SOD');
INSERT INTO ORDERS VALUES('200129', '2500.00', '500.00', '07/20/2008', 'C00024',
'A006', 'SOD');
INSERT INTO ORDERS VALUES('200127', '2500.00', '400.00', '07/20/2008', 'C00015',
'A003', 'SOD');
INSERT INTO ORDERS VALUES('200128', '3500.00', '1500.00', '07/20/2008', 'C00009',
'A002', 'SOD');
INSERT INTO ORDERS VALUES('200135', '2000.00', '800.00', '09/16/2008', 'C00007',
'A010', 'SOD');
INSERT INTO ORDERS VALUES('200131', '900.00', '150.00', '08/26/2008', 'C00012',
'A012', 'SOD');
INSERT INTO ORDERS VALUES('200133', '1200.00', '400.00', '06/29/2008', 'C00009',
'A002', 'SOD');

-- phpMyAdmin SQL Dump

-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 08, 2014 at 06:53 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `sample`
--

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

--
-- Table structure for table `agents`
--

CREATE TABLE IF NOT EXISTS `agents` (

`AGENT_CODE` varchar(6) NOT NULL DEFAULT '',
`AGENT_NAME` varchar(40) DEFAULT NULL,
`WORKING_AREA` varchar(35) DEFAULT NULL,
`COMMISSION` decimal(10,2) DEFAULT NULL,
`PHONE_NO` varchar(15) DEFAULT NULL,
`COUNTRY` varchar(25) DEFAULT NULL,
PRIMARY KEY (`AGENT_CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agents`
--

INSERT INTO `agents` (`AGENT_CODE`, `AGENT_NAME`, `WORKING_AREA`, `COMMISSION`,

`PHONE_NO`, `COUNTRY`) VALUES
('A007 ', 'Ramasundar ',
'Bangalore ', '0.15', '077-25814763 ', '\r'),
('A003 ', 'Alex ',
'London ', '0.13', '075-12458969 ', '\r'),
('A008 ', 'Alford ', 'New
York ', '0.12', '044-25874365 ', '\r'),
File: /home/mfarooq33/Documents/SQL Queries Page 5 of 10

('A011 ', 'Ravi Kumar ',

'Bangalore ', '0.15', '077-45625874 ', '\r'),
('A010 ', 'Santakumar ',
'Chennai ', '0.14', '007-22388644 ', '\r'),
('A012 ', 'Lucida ', 'San
Jose ', '0.12', '044-52981425 ', '\r'),
('A005 ', 'Anderson ',
'Brisban ', '0.13', '045-21447739 ', '\r'),
('A001 ', 'Subbarao ',
'Bangalore ', '0.14', '077-12346674 ', '\r'),
('A002 ', 'Mukesh ',
'Mumbai ', '0.11', '029-12358964 ', '\r'),
('A006 ', 'McDen ',
'London ', '0.15', '078-22255588 ', '\r'),
('A004 ', 'Ivan ',
'Torento ', '0.15', '008-22544166 ', '\r'),
('A009 ', 'Benjamin ',
'Hampshair ', '0.11', '008-22536178 ', '\r');

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

--
-- Table structure for table `company`
--

CREATE TABLE IF NOT EXISTS `company` (

`COMPANY_ID` varchar(6) NOT NULL DEFAULT '',
`COMPANY_NAME` varchar(25) DEFAULT NULL,
`COMPANY_CITY` varchar(25) DEFAULT NULL,
PRIMARY KEY (`COMPANY_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`COMPANY_ID`, `COMPANY_NAME`, `COMPANY_CITY`) VALUES

('18', 'Order All', 'Boston\r'),
('15', 'Jack Hill Ltd', 'London\r'),
('16', 'Akas Foods', 'Delhi\r'),
('17', 'Foodies.', 'London\r'),
('19', 'sip-n-Bite.', 'New York\r');

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (

`CUST_CODE` varchar(6) NOT NULL,
`CUST_NAME` varchar(40) NOT NULL,
`CUST_CITY` varchar(35) DEFAULT NULL,
`WORKING_AREA` varchar(35) NOT NULL,
`CUST_COUNTRY` varchar(20) NOT NULL,
`GRADE` decimal(10,0) DEFAULT NULL,
`OPENING_AMT` decimal(12,2) NOT NULL,
`RECEIVE_AMT` decimal(12,2) NOT NULL,
`PAYMENT_AMT` decimal(12,2) NOT NULL,
`OUTSTANDING_AMT` decimal(12,2) NOT NULL,
`PHONE_NO` varchar(17) NOT NULL,
`AGENT_CODE` varchar(6) DEFAULT NULL,
KEY `CUSTCITY` (`CUST_CITY`),
KEY `CUSTCITY_COUNTRY` (`CUST_CITY`,`CUST_COUNTRY`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
File: /home/mfarooq33/Documents/SQL Queries Page 6 of 10

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`CUST_CODE`, `CUST_NAME`, `CUST_CITY`, `WORKING_AREA`,

`CUST_COUNTRY`, `GRADE`, `OPENING_AMT`, `RECEIVE_AMT`, `PAYMENT_AMT`,
`OUTSTANDING_AMT`, `PHONE_NO`, `AGENT_CODE`) VALUES
('C00013', 'Holmes', 'London ', 'London', 'UK', '2',
'6000.00', '5000.00', '7000.00', '4000.00', 'BBBBBBB', 'A003 '),
('C00001', 'Micheal', 'New York ', 'New York', 'USA',
'2', '3000.00', '5000.00', '2000.00', '6000.00', 'CCCCCCC', 'A008 '),
('C00020', 'Albert', 'New York ', 'New York', 'USA',
'3', '5000.00', '7000.00', '6000.00', '6000.00', 'BBBBSBB', 'A008 '),
('C00025', 'Ravindran', 'Bangalore ', 'Bangalore',
'India', '2', '5000.00', '7000.00', '4000.00', '8000.00', 'AVAVAVA', 'A011 '),
('C00024', 'Cook', 'London ', 'London', 'UK', '2',
'4000.00', '9000.00', '7000.00', '6000.00', 'FSDDSDF', 'A006 '),
('C00015', 'Stuart', 'London ', 'London', 'UK', '1',
'6000.00', '8000.00', '3000.00', '11000.00', 'GFSGERS', 'A003 '),
('C00002', 'Bolt', 'New York ', 'New York', 'USA', '3',
'5000.00', '7000.00', '9000.00', '3000.00', 'DDNRDRH', 'A008 '),
('C00018', 'Fleming', 'Brisban ', 'Brisban',
'Australia', '2', '7000.00', '7000.00', '9000.00', '5000.00', 'NHBGVFC', 'A005 '),
('C00021', 'Jacks', 'Brisban ', 'Brisban', 'Australia',
'1', '7000.00', '7000.00', '7000.00', '7000.00', 'WERTGDF', 'A005 '),
('C00019', 'Yearannaidu', 'Chennai ', 'Chennai',
'India', '1', '8000.00', '7000.00', '7000.00', '8000.00', 'ZZZZBFV', 'A010 '),
('C00005', 'Sasikant', 'Mumbai ', 'Mumbai', 'India',
'1', '7000.00', '11000.00', '7000.00', '11000.00', '147-25896312', 'A002 '),
('C00007', 'Ramanathan', 'Chennai ', 'Chennai',
'India', '1', '7000.00', '11000.00', '9000.00', '9000.00', 'GHRDWSD', 'A010 '),
('C00022', 'Avinash', 'Mumbai ', 'Mumbai', 'India',
'2', '7000.00', '11000.00', '9000.00', '9000.00', '113-12345678', 'A002 '),
('C00004', 'Winston', 'Brisban ', 'Brisban',
'Australia', '1', '5000.00', '8000.00', '7000.00', '6000.00', 'AAAAAAA', 'A005 '),
('C00023', 'Karl', 'London ', 'London', 'UK', '0',
'4000.00', '6000.00', '7000.00', '3000.00', 'AAAABAA', 'A006 '),
('C00006', 'Shilton', 'Torento ', 'Torento', 'Canada',
'1', '10000.00', '7000.00', '6000.00', '11000.00', 'DDDDDDD', 'A004 '),
('C00010', 'Charles', 'Hampshair ', 'Hampshair', 'UK',
'3', '6000.00', '4000.00', '5000.00', '5000.00', 'MMMMMMM', 'A009 '),
('C00017', 'Srinivas', 'Bangalore ', 'Bangalore',
'India', '2', '8000.00', '4000.00', '3000.00', '9000.00', 'AAAAAAB', 'A007 '),
('C00012', 'Steven', 'San Jose ', 'San Jose', 'USA',
'1', '5000.00', '7000.00', '9000.00', '3000.00', 'KRFYGJK', 'A012 '),
('C00008', 'Karolina', 'Torento ', 'Torento', 'Canada',
'1', '7000.00', '7000.00', '9000.00', '5000.00', 'HJKORED', 'A004 '),
('C00003', 'Martin', 'Torento ', 'Torento', 'Canada',
'2', '8000.00', '7000.00', '7000.00', '8000.00', 'MJYURFD', 'A004 '),
('C00009', 'Ramesh', 'Mumbai ', 'Mumbai', 'India',
'3', '8000.00', '7000.00', '3000.00', '12000.00', 'Phone No', 'A002 '),
('C00014', 'Rangarappa', 'Bangalore ', 'Bangalore',
'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'AAAATGF', 'A001 '),
('C00016', 'Venkatpati', 'Bangalore ', 'Bangalore',
'India', '2', '8000.00', '11000.00', '7000.00', '12000.00', 'JRTVFDD', 'A007 '),
('C00011', 'Sundariya', 'Chennai ', 'Chennai', 'India',
'3', '7000.00', '11000.00', '7000.00', '11000.00', 'PPHGRTS', 'A010 ');

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

--
-- Table structure for table `daysorder`
--

CREATE TABLE IF NOT EXISTS `daysorder` (

`ORD_NUM` decimal(6,0) NOT NULL,
File: /home/mfarooq33/Documents/SQL Queries Page 7 of 10

`ORD_AMOUNT` decimal(12,2) NOT NULL,

`ADVANCE_AMOUNT` decimal(12,2) NOT NULL,
`ORD_DATE` date NOT NULL,
`CUST_CODE` varchar(6) NOT NULL,
`AGENT_CODE` varchar(6) NOT NULL,
`ORD_DESCRIPTION` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daysorder`
--

INSERT INTO `daysorder` (`ORD_NUM`, `ORD_AMOUNT`, `ADVANCE_AMOUNT`, `ORD_DATE`,

`CUST_CODE`, `AGENT_CODE`, `ORD_DESCRIPTION`) VALUES
('200107', '4500.00', '900.00', '2008-08-30', 'C00007', 'A010', 'SOD\r'),
('200114', '3500.00', '1500.00', '2008-08-15', 'C00002', 'A008', 'SOD\r'),
('200134', '4200.00', '1800.00', '2008-09-25', 'C00004', 'A005', 'SOD\r'),
('200115', '2000.00', '1200.00', '2008-02-08', 'C00013', 'A013', 'SOD\r'),
('200101', '3000.00', '1000.00', '2008-07-15', 'C00001', 'A008', 'SOD\r'),
('200128', '3500.00', '1500.00', '2008-07-20', 'C00009', 'A002', 'SOD\r'),
('200132', '4000.00', '1500.00', '2008-08-15', 'C00013', 'A013', 'SOD\r');

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

--
-- Table structure for table `despatch`
--

CREATE TABLE IF NOT EXISTS `despatch` (

`DES_NUM` varchar(6) NOT NULL DEFAULT '',
`DES_DATE` date DEFAULT NULL,
`DES_AMOUNT` decimal(12,2) DEFAULT NULL,
`ORD_NUM` decimal(6,0) DEFAULT NULL,
`ORD_DATE` date DEFAULT NULL,
`ORD_AMOUNT` decimal(12,2) DEFAULT NULL,
`AGENT_CODE` varchar(6) DEFAULT NULL,
PRIMARY KEY (`DES_NUM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `despatch`
--

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

--
-- Table structure for table `foods`
--

CREATE TABLE IF NOT EXISTS `foods` (

`ITEM_ID` varchar(6) NOT NULL DEFAULT '',
`ITEM_NAME` varchar(25) DEFAULT NULL,
`ITEM_UNIT` varchar(5) DEFAULT NULL,
`COMPANY_ID` varchar(6) DEFAULT NULL,
PRIMARY KEY (`ITEM_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `foods`
--

INSERT INTO `foods` (`ITEM_ID`, `ITEM_NAME`, `ITEM_UNIT`, `COMPANY_ID`) VALUES

('1', 'Chex Mix', 'Pcs', '16\r'),
('6', 'Cheez-It', 'Pcs', '15\r'),
('2', 'BN Biscuit', 'Pcs', '15\r'),
File: /home/mfarooq33/Documents/SQL Queries Page 8 of 10

('3', 'Mighty Munch', 'Pcs', '17\r'),

('4', 'Pot Rice', 'Pcs', '15\r'),
('5', 'Jaffa Cakes', 'Pcs', '18\r'),
('7', 'Salt n Shake', 'Pcs', '\r');

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

--
-- Table structure for table `listofitem`
--

CREATE TABLE IF NOT EXISTS `listofitem` (

`ITEMCODE` varchar(6) NOT NULL,
`ITEMNAME` varchar(25) NOT NULL,
`BATCHCODE` varchar(35) NOT NULL,
`CONAME` varchar(35) DEFAULT NULL,
UNIQUE KEY `ITEMCODE` (`ITEMCODE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `listofitem`
--

INSERT INTO `listofitem` (`ITEMCODE`, `ITEMNAME`, `BATCHCODE`, `CONAME`) VALUES

('I001 ', 'CHOCOLATE ', 'DM/2007-08/WBM%1 ',
'\r'),
('I003 ', 'HOT DOG ', 'DM/2007-08/WB1 ',
'ABJ ENTERPRISE '),
('I002 ', 'CONDENSED MILK ', 'DM/2007-08/WBM%2 ',
'ABJ CONCERN ');

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

--
-- Table structure for table `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (

`ORD_NUM` decimal(6,0) NOT NULL,
`ORD_AMOUNT` decimal(12,2) NOT NULL,
`ADVANCE_AMOUNT` decimal(12,2) NOT NULL,
`ORD_DATE` date NOT NULL,
`CUST_CODE` varchar(6) NOT NULL,
`AGENT_CODE` varchar(6) NOT NULL,
`ORD_DESCRIPTION` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`ORD_NUM`, `ORD_AMOUNT`, `ADVANCE_AMOUNT`, `ORD_DATE`,

`CUST_CODE`, `AGENT_CODE`, `ORD_DESCRIPTION`) VALUES
('200100', '1000.00', '600.00', '2008-01-08', 'C00015', 'A003 ', 'SOD\r'),
('200110', '3000.00', '500.00', '2008-04-15', 'C00019', 'A010 ', 'SOD\r'),
('200107', '4500.00', '900.00', '2008-08-30', 'C00007', 'A010 ', 'SOD\r'),
('200112', '2000.00', '400.00', '2008-05-30', 'C00016', 'A007 ', 'SOD\r'),
('200113', '4000.00', '600.00', '2008-06-10', 'C00022', 'A002 ', 'SOD\r'),
('200102', '2000.00', '300.00', '2008-05-25', 'C00012', 'A012 ', 'SOD\r'),
('200114', '3500.00', '2000.00', '2008-08-15', 'C00002', 'A008 ', 'SOD\r'),
('200122', '2500.00', '400.00', '2008-09-16', 'C00003', 'A004 ', 'SOD\r'),
('200118', '500.00', '100.00', '2008-07-20', 'C00023', 'A006 ', 'SOD\r'),
('200119', '4000.00', '700.00', '2008-09-16', 'C00007', 'A010 ', 'SOD\r'),
('200121', '1500.00', '600.00', '2008-09-23', 'C00008', 'A004 ', 'SOD\r'),
('200130', '2500.00', '400.00', '2008-07-30', 'C00025', 'A011 ', 'SOD\r'),
('200134', '4200.00', '1800.00', '2008-09-25', 'C00004', 'A005 ', 'SOD\r'),
File: /home/mfarooq33/Documents/SQL Queries Page 9 of 10

('200115', '2000.00', '1200.00', '2008-02-08', 'C00013', 'A013 ', 'SOD\r'),

('200108', '4000.00', '600.00', '2008-02-15', 'C00008', 'A004 ', 'SOD\r'),
('200103', '1500.00', '700.00', '2008-05-15', 'C00021', 'A005 ', 'SOD\r'),
('200105', '2500.00', '500.00', '2008-07-18', 'C00025', 'A011 ', 'SOD\r'),
('200109', '3500.00', '800.00', '2008-07-30', 'C00011', 'A010 ', 'SOD\r'),
('200101', '3000.00', '1000.00', '2008-07-15', 'C00001', 'A008 ', 'SOD\r'),
('200111', '1000.00', '300.00', '2008-07-10', 'C00020', 'A008 ', 'SOD\r'),
('200104', '1500.00', '500.00', '2008-03-13', 'C00006', 'A004 ', 'SOD\r'),
('200106', '2500.00', '700.00', '2008-04-20', 'C00005', 'A002 ', 'SOD\r'),
('200125', '2000.00', '600.00', '2008-10-10', 'C00018', 'A005 ', 'SOD\r'),
('200117', '800.00', '200.00', '2008-10-20', 'C00014', 'A001 ', 'SOD\r'),
('200123', '500.00', '100.00', '2008-09-16', 'C00022', 'A002 ', 'SOD\r'),
('200120', '500.00', '100.00', '2008-07-20', 'C00009', 'A002 ', 'SOD\r'),
('200116', '500.00', '100.00', '2008-07-13', 'C00010', 'A009 ', 'SOD\r'),
('200124', '500.00', '100.00', '2008-06-20', 'C00017', 'A007 ', 'SOD\r'),
('200126', '500.00', '100.00', '2008-06-24', 'C00022', 'A002 ', 'SOD\r'),
('200129', '2500.00', '500.00', '2008-07-20', 'C00024', 'A006 ', 'SOD\r'),
('200127', '2500.00', '400.00', '2008-07-20', 'C00015', 'A003 ', 'SOD\r'),
('200128', '3500.00', '1500.00', '2008-07-20', 'C00009', 'A002 ', 'SOD\r'),
('200135', '2000.00', '800.00', '2008-09-16', 'C00007', 'A010 ', 'SOD\r'),
('200131', '900.00', '150.00', '2008-08-26', 'C00012', 'A012 ', 'SOD\r'),
('200133', '1200.00', '400.00', '2008-06-29', 'C00009', 'A002 ', 'SOD\r'),
('200132', '4000.00', '2000.00', '2008-08-15', 'C00013', 'A013 ', 'SOD\r');

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

--
-- Table structure for table `student`
--

CREATE TABLE IF NOT EXISTS `student` (

`NAME` varchar(30) NOT NULL,
`TITLE` varchar(25) NOT NULL,
`CLASS` varchar(5) NOT NULL,
`SECTION` varchar(1) NOT NULL,
`ROLLID` decimal(3,0) NOT NULL,
PRIMARY KEY (`CLASS`,`SECTION`,`ROLLID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`NAME`, `TITLE`, `CLASS`, `SECTION`, `ROLLID`) VALUES

('Deepak ', 'Saxana ', 'V ', 'A',
'15'),
('Robert ', 'Paul ', 'VI ', 'A', '2'),
('Danny ', 'Moris ', 'V ', 'B',
'15');

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

--
-- Table structure for table `studentreport`
--

CREATE TABLE IF NOT EXISTS `studentreport` (

`CLASS` varchar(5) NOT NULL,
`SECTION` varchar(1) NOT NULL,
`ROLLID` decimal(3,0) NOT NULL,
`GRADE` varchar(5) NOT NULL,
`SEMISTER` varchar(5) DEFAULT NULL,
`CLASS_ATTENDED` decimal(25,0) DEFAULT NULL,
KEY `FK_CSR` (`CLASS`,`SECTION`,`ROLLID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
File: /home/mfarooq33/Documents/SQL Queries Page 10 of 10

--
-- Dumping data for table `studentreport`
--

INSERT INTO `studentreport` (`CLASS`, `SECTION`, `ROLLID`, `GRADE`, `SEMISTER`,

`CLASS_ATTENDED`) VALUES
('V ', 'A', '15', 'A++ ', '1St ', '75'),
('VI ', 'A', '2', 'A+ ', '2Nd ', '70'),
('V ', 'B', '15', 'AA ', '1St ', '85'),
('VI ', 'A', '2', 'A+ ', '1St ', '70'),
('V ', 'A', '15', 'AA ', '2Nd ', '85');