Display all course sections offered in Winter 2003.

Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)


```
SQL> SELECT CourseId, Section, TermId
2 FROM crssection
3 WHERE TermId = 'WN03';

COURSE SE TERM
------ -- ----
CIS265 01 WN03
CIS253 01 WN03
MA150 02 WN03
AC101 10 WN03
```

Computer Science & Information Technology

You might also like to view...

Find the error(s) in each of the following program segments, and explain how the error(s) can be corrected

a) ``` int g() { cout << "Inside function g" << endl; int h() { cout << "Inside function h" << endl; } } ``` b) ``` int sum( int x, int y ) { int result; result = x + y; } ``` c) ``` int sum( int n ) { if ( n == 0 ) return 0; else n + sum( n - 1 ); } ``` d) ``` void f( double a ); { float a; cout << a << endl; } ``` e) ``` void product() { int a; int b; int c; int result; cout << "Enter three integers: "; cin >> a >> b >> c; result = a * b * c; cout << "Result is " << result; return result; } ```

Computer Science & Information Technology

Programs often need to store values in the computer's RAM

Indicate whether the statement is true or false

Computer Science & Information Technology

You can add new pages to a publication by clicking the ____ tab on the Ribbon, and then clicking the Page button in the Pages group.

A. Home B. Insert C. View D. Review

Computer Science & Information Technology

In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.

A. left inner join B. left outer join C. right outer join D. right inner join

Computer Science & Information Technology