SQL 1. List slCensus. TripID and PaxCnt for trips in the year 2010 for which the captain took the ship out alone (solo). PaxCnt is the count of the number of passengers (PaxID) in 2010 where the count is equal to 1. Order the list by slCensus. TripID in ascending order.
2. List TripDuration and AVGwaterTemp for trips taken by passenger with slCensus. PaxID = 173 for trips where the duration of the trip was greater than 1 hour. TripDuration is the difference between slTrip. TripStart and slTrip. TripEnd in hours. Produce the values for and group by TripDuration using DATEDIFF and the HOUR interval. Order the list by TripDuration in ascending order.
3. List DISTINCT slWayPoint. WayPoint for passenger with slCensus. PaxID 108 for trips in the year 2010. Order the list by slWayPoint. WayPoint in ascending order.
4. List the Last time the ship was launched from the Causeway where waypoint Pinto Island was on the float plan. LastTrip is the maximum value of slTrip. TripStart where the launchID is 2 and waypointID is 932

Now you’re on your own. include a short summary of this section with plots in your lab report. write a matlab script file to do steps (a) through (d) below. include a listing of the script file with your report. 1 the soundsc(xx,fs) function requires two arguments: the first one (xx) contains the vector of data to be played, the second argument (fs) is the sampling rate for playing the samples. in addition, soundsc(xx,fs) does automatic scaling and then calls sound(xx,fs) to actually play the signal. mcclellan, schafer, and yoder, dsp first, 2e, isbn 0-13-065562-7. prentice hall, upper saddle river, nj 07458. c 2015 pearson education, inc. 4 mcclellan, schafer and yoder, signal processing first. prentice hall, upper saddle river, new jersey, 2003. c 2003 prentice hall. (a) generate a time vector (tt) to cover a range of t that will exhibit approximately two cycles of the 4000 hz sinusoids defined in the next part, part (b). use a definition for tt similar to part 2.2(d). if we use t to denote the period of the sinusoids, define the starting time of the vector tt to be equal to t , and the ending time as ct . then the two cycles will include t d 0. finally, make sure that you have at least 25 samples per period of the sinusoidal wave. in other words, when you use the colon operator to define the time vector, make the increment small enough to generate 25 samples per period. (b) generate two 4000 hz sinusoids with arbitrary amplitude and time-shift. x1.t / d a1 cos.2