/
initial.db.sqbpro
9 lines (9 loc) · 1.08 KB
/
initial.db.sqbpro
1
2
3
4
5
6
7
8
9
<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="/Users/rkim/Documents/UT/CS/BTHO-TAMU-Registration/initial.db" foreign_keys="1"/><window><current_tab id="1"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="100"/><column_width id="3" width="880"/><expanded_item id="0" parent="1"/><expanded_item id="0" parent="0"/><expanded_item id="1" parent="0"/><expanded_item id="1" parent="1"/><expanded_item id="2" parent="1"/><expanded_item id="3" parent="1"/></tab_structure><tab_browse><current_table name="agg"/><default_encoding codec=""/><browsetable_info data="AAAAAgAAABQAcwBlAG0AXwBnAHIAYQBkAGUAcwAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////AAAAAP////8AAAAGAGEAZwBnAAAAAAAAAAAAAAAAAAAAAAAAAAAA//////////8AAAAA/////w=="/></tab_browse><tab_sql><sql name="SQL 1">INSERT INTO aggregate
SELECT prof,
dept,
course_nbr,
course_name,
SUM(a), SUM(b), SUM(c), SUM(d), SUM(f), SUM(totalAF)
FROM section_grades
GROUP BY prof, dept, course_nbr, course_name
</sql><sql name="SQL 1"></sql><current_tab id="1"/></tab_sql></sqlb_project>