Browse 531 attributed reviews, viewable separately for our classroom and online training

Details for FloridaMan

FloridaMan has participated in the following threads:

Added by FloridaMan on 23 Sep 2021 at 12:34

select c.CategoryName as Category_Name

  , count(c.CategoryName) as Number_of_events

from [dbo].[tblEvent] e

left join [dbo].[tblCategory] c

on e.CategoryID = c.CategoryID

group by c.CategoryName

order by Number_of_events desc

***BOOM,DONE***

Added by FloridaMan on 23 Sep 2021 at 12:40

 

select c.CategoryName as Category_Name

  , count(c.CategoryName) as Number_of_events

  , max(e.EventDate) as Last_Date

  , min(e.EventDate) as First_Date

from [dbo].[tblEvent] e

left join [dbo].[tblCategory] c

on e.CategoryID = c.CategoryID

group by c.CategoryName

order by Number_of_events desc

Added by FloridaMan on 23 Sep 2021 at 14:40

select max(con.ContinentName) as Continent_Name

, cou.CountryName as Country_Name

, count(e.EventName) as Number_of_Events

   from [dbo].[tblEvent] e

left join [dbo].[tblCategory] c

on e.CategoryID = c.CategoryID

left join [dbo].[tblCountry] cou

on e.CountryID = cou.CountryID

left join [dbo].[tblContinent] con

on cou.ContinentID = con.ContinentID

 

where ContinentName not in('Europe') 

group by cou.CountryName

having  count(e.EventName)  >= 5

order by cou.CountryName

Added by FloridaMan on 24 Sep 2021 at 15:52

select 
           left (c.CategoryName ,1) as Category_Initial
        ,  count (e.EventName)   as Number_of_Events
        , sum(len (e.EventName)) as Total_Length
        , cast(avg( cast(   len (e.EventName)  as float  )  ) as decimal(6,2) ) as AVG_Event_Name_Length
        from [dbo].[tblEvent] e
        left join [dbo].[tblCategory] c
        on e.CategoryID = c.CategoryID

        group by left (c.CategoryName ,1) 

Added by FloridaMan on 26 Sep 2021 at 01:28

select *

from 

[dbo].[tblEpisode] e

left join [dbo].[tblEpisodeCompanion] ec

on e.EpisodeId = ec.EpisodeId

--where e.EpisodeId is null

full outer join [dbo].[tblCompanion] c

on ec.CompanionId = c.CompanionId

Added by FloridaMan on 26 Sep 2021 at 13:43

Not sure if I can post this, BUT I found a great video explaining this. 

 

https://youtu.be/ck8mVDOOCCg