blake blakewrege

## 4430 A1 #1
π names σ zip = 49008 U zip = 49009 (zip codes)

## 4430 A2 #3
SELECT * from (enrolled left join class
on enrolled.cname=class.cname)
union
SELECT * from (enrolled right join class
on enrolled.cname=class.cname);

SELECT *from (class left join faculty
on class.fid=faculty.fid)
union
SELECT * from (class right join faculty

## A2 E1 #12
SELECT student.standing,group_concat(student.age)
FROM lab.student
group by student.standing;

## hello world minicom msp430
#include <msp430.h>
#include <libemb/serial/serial.h>
#include <libemb/conio/conio.h>
#include <libemb/shell/shell.h>
#include <ctype.h>
#include <stdlib.h>
#include <string.h>
main(void){
  WDTCTL = WDTPW | WDTHOLD;
  BCSCTL1 = CALBC1_1MHZ;

## convert.c
// This program will convert unsigned int values for output in various bases
// including 2<= Base <= 16 and Base = 256
// There will be a Convert(Value, Base) routine called with hard coded values from main
// The Base = 256 case will be handled separately.
//
#include <stdio.h>

void Convert(unsigned int,unsigned int);
void DoOtherConvert(unsigned int);
int main()

## A3 E1 #3
use lab;
create trigger test
before insert on class.fid
for each row
begin
from class
end;

## movebits
#include <msp430.h>


            .text
RESET       mov.w   #__STACK_END,SP


            MOV     #WDTPW+WDTHOLD, &WDTCTL

## cs4430 A4 #1
<html>
<body>
<?php
$servername = "localhost";
$username = "testuser";
$password = "test623";
$dbname = "lab2";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

## cs4430 A5
drop database lab3;
create database lab3;
use lab3;

create table addresses(
  a_id     integer auto_increment primary key,
  street   varchar(20),
  zip      varchar(9),
  city     varchar(40),
  state    char(2)

## lottery.c
#include <msp430.h>
#include <libemb/serial/serial.h>
#include <libemb/conio/conio.h>
#include <libemb/shell/shell.h>

#define push (P1IN&BIT3)

int p1[4] = {
BIT5,BIT6,BIT7,
BIT4+BIT6+BIT7,
	SELECT * from (enrolled left join class
	on enrolled.cname=class.cname)
	union
	SELECT * from (enrolled right join class
	on enrolled.cname=class.cname);

	SELECT *from (class left join faculty
	on class.fid=faculty.fid)
	union
	SELECT * from (class right join faculty
	SELECT student.standing,group_concat(student.age)
	FROM lab.student
	group by student.standing;
	#include <msp430.h>
	#include <libemb/serial/serial.h>
	#include <libemb/conio/conio.h>
	#include <libemb/shell/shell.h>
	#include <ctype.h>
	#include <stdlib.h>
	#include <string.h>
	main(void){
	WDTCTL = WDTPW \| WDTHOLD;
	BCSCTL1 = CALBC1_1MHZ;
	// This program will convert unsigned int values for output in various bases
	// including 2<= Base <= 16 and Base = 256
	// There will be a Convert(Value, Base) routine called with hard coded values from main
	// The Base = 256 case will be handled separately.
	//
	#include <stdio.h>

	void Convert(unsigned int,unsigned int);
	void DoOtherConvert(unsigned int);
	int main()
	use lab;
	create trigger test
	before insert on class.fid
	for each row
	begin
	from class
	end;
	#include <msp430.h>




	.text
	RESET mov.w #__STACK_END,SP


	MOV #WDTPW+WDTHOLD, &WDTCTL
	<html>
	<body>
	<?php
	$servername = "localhost";
	$username = "testuser";
	$password = "test623";
	$dbname = "lab2";

	// Create connection
	$conn = new mysqli($servername, $username, $password, $dbname);
	drop database lab3;
	create database lab3;
	use lab3;

	create table addresses(
	a_id integer auto_increment primary key,
	street varchar(20),
	zip varchar(9),
	city varchar(40),
	state char(2)