16 Matching Annotations
  1. Jan 2023
    1. hat you need is to filter on the count of the number of races for each horse. The HAVING clause does exactly what we need here – it has syntax like the WHERE clause, but it is applied to each group after grouping has taken place

      Main diff between HAVING and WHERE

        • WHERE is applied before grouping, it is usually used to narrow the SELECT statement's output
        • HAVING is applied after grouping. It is usually used when grouping is needed to incorporate function generated values into a new table requested by the query
    2. GROUP BY clause directs the DBMS to form groups of rows for each value of the column(s) named in the clause, returning one row in the result set for each group
  2. Mar 2021
  3. Nov 2020
    1. Though we have covered a lot, there is one more feature of window functions that can give you even more analytical power. It's called the "frame clause," and it allows you to calculate things like rolling averages, cumulative sums, and many other interesting values.
  4. Sep 2020
  5. Apr 2018
    1. So far it is from being true, that a bill of rights is less necessary in the general constitution than in those of the states, the contrary is evidently the fact. — This system, if it is possible for the people of America to accede to it, will be an original compact; and being the last, will, in the nature of things, vacate every former agreement inconsistent with it. For it being a plan of government received and ratified by the whole people, all other forms, which are in existence at the time of its adoption, must yield to it. This is expressed in positive and unequivocal terms, in the 6th article, “That this constitution and the laws of the United States, which shall be made in pursuance thereof, and all treaties made, or which shall be made, under the authority of the United States, shall be the supreme law of the land; and the judges in every state shall be bound thereby, any thing in the constitution, or laws of any state, to the contrary notwithstanding.

      Would probably try to address the following w/ my students. Was Brutus correct (in either the short term or the long run)? Did this clause of the Constitution supersede or usurp state gov't authority? If so, specific historical examples and or Supreme court precedent cases??

  6. May 2016
    1. If Turnitin is involved in a merger, acquisition, or sale of all or a portion of its assets, you will be notified via email and/or a prominent notice on our website, of any change in ownership, uses of your personal information, and choices you may have regarding your personal information.

      A. merger voids any privacy pledges. The new owner has no requirement to follow these policys.

      B. The information is kept for an extended period of time. Once a teacher leaves a school district, their email will be invalid. It's a vacuous promise to say that they'll be contacted.

  7. Oct 2015