Lupus

Join us for a fun Saturday evening starting with dinner at Ranchero Kitchen at 6:30 PM, where we’ll be supporting an immigrant-owned local business. Pupusas: Beans, Potatoes, Veggie Homemade juices: Passionfruit, Tamarind, Horchata, Pineapple-cashew After dinner, we’ll head to Skate Zone 71 from 8:00–10:30 PM for skating, music, and good vibes. Come hungry and ready to roll! 😋🛼 Locations: Ranchero Kitchen 984 Morse Rd Columbus, OH 43229 (Same plaza as Ohio BMV license bureau) Skate Zone 71 4900 Evanswood Dr Columbus, OH 43229

**Caller: Frank Buschelmann** **Band: The Rosenthorns** **Big Scioty Contra Dance** **temporarily returning to our long ago location for Jan-March - First Congregational Church, 444 E. Broad St., Columbus 43215** WHAT IS CONTRA DANCING? Picture the Grand Ball scenes like you’ve seen in period films such as “Pride and Prejudice”, where the dancers are lined up in long lines, across from each other. That’s English Country Dancing, the predecessor of contra dancing. Now, add moves like “swing your partner” and “do-si-do,” like you’ve seen in square dancing. Set it to fabulous, high energy, live music with fiddles, guitars, percussion and more, alá “Riverdance.” Finally, set the whole scene down in the middle of Woodstock, with a hip, groovy atmosphere, a bit of tie-dye, and hints of counter-culture attitude. THAT’s Contra Dancing! Wear cool and comfortable clothes (you will get warm) and clean shoes that won't mark up our nice wood floor. Be sure to come for the beginner's lesson from 7:30 - 8:00, followed by dancing 8:00 - 10:30. All dances are taught; we will help you learn! Beginners always welcome, no need to bring a partner. Cost is $10.00 adults, $5.00 ages 12-26. Under 12 free. Free parking in church lot. For more information contact me or check out our website: [www.bigscioty.com](http://www.bigscioty.com/) Please bring your own refillable water bottle. Snacks to share are always welcome!

# **Band and caller TBA** Beginner lesson at 1:30, regular dancing begins at 2:00 pm NOTE THAT WE ARE TEMPORARILY DANCING IN THE AFTERNOON INSTEAD OF EVENING. Dance with us in the afternoon then you can still go out in the evening! **Sponsor: All Soles Contra and Square Dancing, First Unitarian Universalist Church, 93 W. Weisheimer Rd., Columbus OH 43214** WHAT IS CONTRA DANCING? Picture the Grand Ball scenes like you’ve seen in period films such as “Pride and Prejudice”, where the dancers are lined up in long lines, across from each other. That’s English Country Dancing, the predecessor of contra dancing. Now, add moves like “swing your partner” and “do-si-do,” like you’ve seen in square dancing. Set it to fabulous, high energy, live music with fiddles, guitars, percussion and more, alá “Riverdance.” Finally, set the whole scene down in the middle of Woodstock, with a hip, groovy atmosphere, a bit of tie-dye, and hints of counter-culture attitude. THAT’s Contra Dancing! Wear cool and comfortable clothes (you will get warm) and clean shoes that won't mark up our nice wood floor. Be sure to come for the beginner's lesson from 1:30 - 2:00, followed by dancing 2:00 - 430. All dances are taught; we will help you learn! Beginners always welcome, no need to bring a partner. Cost is $10.00 adults, $5.00 ages 12-26. Under 12 free. Free parking in church lot. Please bring your own refillable water bottle.

This month, we are in-person at GameArena!!! We will also be joined by students and their games from [Shawnee State](https://www.shawnee.edu/game-design-programs)! \-\-\- Join us for our our monthly COGG Prototype and Play event @GameArena! Come to play and showcase your games. We're back in the upper levels of the catwalk mezzanine area. It'll be packed with lots of camaraderie playing your game(s) and other's games on the 2nd floor as well as the 1st floor in the gaming room below the mezzanine. Light snacks and water provided but you can buy food and drinks at the bar (alcoholic drink ID required). [https://www.game-arena.co/menu](https://www.game-arena.co/menu) **Attendees:** Don't have a game to show? Not a problem! All are welcomed and invited from all ages and backgrounds. The more we can have to play test our games the better! **Developers:** Do you have a game that you would like to get critical feedback on? Would you like an excuse to work on a game with other talented artists, programmers, musicians, designers, and writers? Digital, table-top, non-experienced developers, and the like are welcomed! We'll provide signage for your game to help others learn more about your work. Wifi, outlets, tables, and seats (though standing tables also) are available. Come to the Prototype and Play workshop to collaborate and meet local game developers for an evening of epic and raw game play fun! Play works-in-progress, show off your own game, work with others to add polish to a game, or even lend your talents to other fellow developers. Can use South Garage at the Gateway with a $5 voucher on your way out. 75 E 11th Ave, Columbus, OH 43201 [https://maps.app.goo.gl/UwgveUYG37Jy7RtS9](https://maps.app.goo.gl/UwgveUYG37Jy7RtS9) If you have any questions or comments, as always, feel free to reach out to us at [info@thecogg.com!](http://info@thecogg.com!/)

Window functions have nothing to do with the Windows operating system but provide a “window” to a result set when used in SQL queries. They are powerful, set-based methods to view data in unexpected ways. Window functions provide easy, set-based solutions to solve some common problems: * Using running totals * Performing operations in intervals * Identifying data gaps and islands * Performing aggregates without losing detail Many people are confused by window functions and do not know how to use them properly. This session will explore window functions, how they work, and how to use them. Demonstrations with several examples will solidify how window functions can simplify queries and make them more powerful.