CREATE TABLE IF NOT EXISTS `student3_avg` (
  `id` int(2) NOT NULL DEFAULT '0',
  `name` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `class` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `social` int(3) NOT NULL DEFAULT '0',
  `science` int(3) NOT NULL,
  `math` int(3) NOT NULL,
  `average` int(3) NOT NULL,
  `average_class` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `student3_avg`
--

INSERT INTO `student3_avg` (`id`, `name`, `class`, `social`, `science`, `math`, `average`, `average_class`) VALUES
(2, 'Max Ruin', 'Three', 86, 57, 86, 0, 0),
(3, 'Arnold', 'Three', 56, 41, 76, 0, 0),
(4, 'Krish Star', 'Four', 62, 52, 72, 0, 0),
(5, 'John Mike', 'Four', 62, 82, 92, 0, 0),
(6, 'Alex John', 'Four', 58, 93, 83, 0, 0),
(7, 'My John Rob', 'Fifth', 79, 64, 74, 0, 0),
(8, 'Asruid', 'Five', 89, 84, 94, 0, 0),
(9, 'Tes Qry', 'Six', 77, 61, 71, 0, 0),
(10, 'Big John', 'Four', 56, 44, 56, 0, 0),
(11, 'New Name', 'Five', 75, 78, 52, 0, 0);