# Challenges **URL:** https://www.techhub.training/c/challenges/5.md?page=3 [Latest](https://www.techhub.training/latest.md) · [Categories](https://www.techhub.training/categories.md) · [Tags](https://www.techhub.training/tags.md) **Page:** 4 --- ## [187|UIPATH – Passion for Payables Part 2](https://www.techhub.training/t/187-uipath-passion-for-payables-part-2/2659)
**Author:** [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson)\ **Replies:** 0\ **Last updated:** [May 2, 2024, 2:27am UTC](https://www.techhub.training/t/187-uipath-passion-for-payables-part-2/2659 "2024-05-02T02:27:23Z")
BYU Student Author: @Andrew\_Wilson Reviewers: @Jack\_Thomas Estimated Time to Solve: 60 Minutes We provide the solution to this challenge using: UIPath Need a program? Click here. Overview You are an accounts paya… --- ## [186|CELONIS – Cougar Hamburger Process Precision](https://www.techhub.training/t/186-celonis-cougar-hamburger-process-precision/2658)
**Author:** [@Jimmy\_Han](https://www.techhub.training/u/Jimmy_Han)\ **Replies:** 0\ **Last updated:** [May 2, 2024, 1:51am UTC](https://www.techhub.training/t/186-celonis-cougar-hamburger-process-precision/2658 "2024-05-02T01:51:30Z")
BYU Student Author: @Jimmy\_Han Reviewers: @Benjamin\_Lau, @Dallin\_Gardner Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Celonis Overview As a fresh recruit specializing in pro… --- ## [185|CELONIS – Trendara](https://www.techhub.training/t/185-celonis-trendara/2657)
**Author:** [@Benjamin\_Lau](https://www.techhub.training/u/Benjamin_Lau)\ **Replies:** 0\ **Last updated:** [May 2, 2024, 1:34am UTC](https://www.techhub.training/t/185-celonis-trendara/2657 "2024-05-02T01:34:06Z")
BYU Student Author: @Benjamin\_Lau Reviewers: @Kyle\_Nilsen Estimated Time to Solve: 15 Minutes We provide the solution to this challenge using: Celonis Celonis is a software company that offers a process mining plat… --- ## [184|CHATGPT – Law Firm Collections](https://www.techhub.training/t/184-chatgpt-law-firm-collections/2656)
**Author:** [@Dallin\_Gardner](https://www.techhub.training/u/Dallin_Gardner)\ **Replies:** 20\ **Last updated:** [February 3, 2025, 5:25pm UTC](https://www.techhub.training/t/184-chatgpt-law-firm-collections/2656 "2025-02-03T17:25:05Z")
BYU Student Author: @Dallin\_Gardner Reviewers: @Jacob\_Dutton, @Carter\_Lee Estimated Time to Solve:\* 15 Minutes We provide the solution to this challenge using: ChatGPT Need a program? Click here. Overview Your un… --- ## [183|CELONIS – Discover Cougar Hamburger Process](https://www.techhub.training/t/183-celonis-discover-cougar-hamburger-process/2655)
**Author:** [@Jimmy\_Han](https://www.techhub.training/u/Jimmy_Han)\ **Replies:** 0\ **Last updated:** [May 2, 2024, 1:10am UTC](https://www.techhub.training/t/183-celonis-discover-cougar-hamburger-process/2655 "2024-05-02T01:10:34Z")
BYU Student Author: @Jimmy\_Han Reviewers: @Trent\_Barlow, @Benjamin\_Lau Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Celonis Celonis is a tool that helps businesses understand… --- ## [181|SQL – Precision Plane Aggregation Adventure](https://www.techhub.training/t/181-sql-precision-plane-aggregation-adventure/2651)
**Author:** [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\ **Replies:** 12\ **Last updated:** [March 13, 2025, 8:44pm UTC](https://www.techhub.training/t/181-sql-precision-plane-aggregation-adventure/2651 "2025-03-13T20:44:21Z")
BYU Student Author: @Sterling\_Lane Reviewers: @Andrew\_Wilson, @Marta\_Ellsworth Estimated Time to Solve: 30 Minutes This is an intro challenge that is part of the SQL Learning Path. We provide the solution to this cha… --- ## [180|SQL – Intro to Filtering and Ordering Data](https://www.techhub.training/t/180-sql-intro-to-filtering-and-ordering-data/2650)
**Author:** [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson)\ **Replies:** 320\ **Last updated:** [February 27, 2025, 6:52pm UTC](https://www.techhub.training/t/180-sql-intro-to-filtering-and-ordering-data/2650 "2025-02-27T18:52:09Z")
BYU Student Author: @Andrew\_Wilson Reviewers: @Sterling\_Lane, @Marta\_Ellsworth Estimated Time to Solve: 20 Minutes This is an intro challenge that is part of the SQL Learning Path. We provide the solution to this cha… --- ## [182|CHATGPT – Avalanche Analysis](https://www.techhub.training/t/182-chatgpt-avalanche-analysis/2649)
**Author:** [@Jacob\_Dutton](https://www.techhub.training/u/Jacob_Dutton)\ **Replies:** 42\ **Last updated:** [March 12, 2025, 4:56pm UTC](https://www.techhub.training/t/182-chatgpt-avalanche-analysis/2649 "2025-03-12T16:56:20Z")
BYU Student Author: @Jacob\_Dutton Reviewers: @Dallin\_Gardner, @Kyle\_Nilsen Estimated Time to Solve: 25 Minutes We provide the solution to this challenge using: ChatGPT 4.0 (This challenge cannot be completed with … --- ## [179|SQL – Group By for Greatness](https://www.techhub.training/t/179-sql-group-by-for-greatness/2648)
**Author:** [@Marta\_Ellsworth](https://www.techhub.training/u/Marta_Ellsworth)\ **Replies:** 316\ **Last updated:** [February 27, 2025, 7:00pm UTC](https://www.techhub.training/t/179-sql-group-by-for-greatness/2648 "2025-02-27T19:00:29Z")
BYU Student Author: @Marta\_Ellsworth Reviewers: @Andrew\_Wilson, @Sterling\_Lane Estimated Time to Solve: 25 Minutes This is an intro challenge that is part of the SQL Learning Path. We provide the solution to this cha… --- ## [178|SQL – Unions with Precision](https://www.techhub.training/t/178-sql-unions-with-precision/2647)
**Author:** [@Marta\_Ellsworth](https://www.techhub.training/u/Marta_Ellsworth)\ **Replies:** 319\ **Last updated:** [February 27, 2025, 6:50pm UTC](https://www.techhub.training/t/178-sql-unions-with-precision/2647 "2025-02-27T18:50:33Z")
BYU Student Author: @Marta\_Ellsworth Reviewers: @Andrew\_Wilson, @Sterling\_Lane Estimated Time to Solve: 25 Minutes This is an intro challenge that is part of the SQL Learning Path. We provide the solution to this cha… --- ## [177|SQL – Intro to Join Statements](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641)
**Author:** [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson)\ **Replies:** 323\ **Last updated:** [February 27, 2025, 6:49pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641 "2025-02-27T18:49:12Z")
BYU Student Author: @Andrew\_Wilson Reviewers: @Sterling\_Lane, @Marta\_Ellsworth Estimated Time to Solve: 20 Minutes This is an intro challenge that is part of the SQL Learning Path. We provide the solution to this cha… --- ## [176|SQL – Precision Plane Data Presentation](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640)
**Author:** [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\ **Replies:** 324\ **Last updated:** [February 27, 2025, 6:36pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640 "2025-02-27T18:36:17Z")
BYU Student Author: @Sterling\_Lane Reviewers: @Andrew\_Wilson, @Marta\_Ellsworth Estimated Time to Solve: 10 Minutes This is an intro challenge that is part of the SQL Learning Path. We provide the solution to this cha… --- ## [175|SQL&CHATGPT – Shelter Shenanigans Again](https://www.techhub.training/t/175-sql-chatgpt-shelter-shenanigans-again/2437)
**Author:** [@Millie\_K\_B](https://www.techhub.training/u/Millie_K_B)\ **Replies:** 2\ **Last updated:** [January 28, 2025, 8:34pm UTC](https://www.techhub.training/t/175-sql-chatgpt-shelter-shenanigans-again/2437 "2025-01-28T20:34:52Z")
BYU Student Author: @Millie\_K\_B Reviewers: @jimmy\_han, @Sterling\_Lane Estimated Time to Solve: 60 Minutes We provide the solution to this challenge using: SQL ChatGPT 3.5 Need a program? Click here. Overview This… --- ## [174|SQL – Super Shelter Shenanigans](https://www.techhub.training/t/174-sql-super-shelter-shenanigans/2436)
**Author:** [@Millie\_K\_B](https://www.techhub.training/u/Millie_K_B)\ **Replies:** 4\ **Last updated:** [March 13, 2025, 2:51am UTC](https://www.techhub.training/t/174-sql-super-shelter-shenanigans/2436 "2025-03-13T02:51:32Z")
BYU Student Author: @Millie\_K\_B Reviewers: @Jacob\_Dutton, @Andrew\_Wilson Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview This challeng… --- ## [173|SQL – Shelter Shenanigans](https://www.techhub.training/t/173-sql-shelter-shenanigans/2434)
**Author:** [@Millie\_K\_B](https://www.techhub.training/u/Millie_K_B)\ **Replies:** 69\ **Last updated:** [March 13, 2025, 2:24am UTC](https://www.techhub.training/t/173-sql-shelter-shenanigans/2434 "2025-03-13T02:24:53Z")
BYU Student Author: @Millie\_K\_B Reviewers: @Marta\_Ellsworth, @James\_Gerstner Estimated Time to Solve: 25 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview This chal… --- ## [172|SQL – Skyline Subquery Sweepstakes](https://www.techhub.training/t/172-sql-skyline-subquery-sweepstakes/2433)
**Author:** [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\ **Replies:** 6\ **Last updated:** [March 11, 2025, 3:53am UTC](https://www.techhub.training/t/172-sql-skyline-subquery-sweepstakes/2433 "2025-03-11T03:53:17Z")
BYU Student Author: @Sterling\_Lane Reviewers: @James\_Gerstner, @Andrew\_Wilson Estimated Time to Solve: 35 minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview Welcome … --- ## [169|SQL – Workforce Wisdom](https://www.techhub.training/t/169-sql-workforce-wisdom/2432)
**Author:** [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson)\ **Replies:** 66\ **Last updated:** [February 27, 2025, 6:55pm UTC](https://www.techhub.training/t/169-sql-workforce-wisdom/2432 "2025-02-27T18:55:52Z")
BYU Student Author: @Andrew\_Wilson Reviewers: @Marta\_Ellsworth, @Jimmy\_Han Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview Congratulat… --- ## [171|SQL – Shelter Shenanigans Sequel](https://www.techhub.training/t/171-sql-shelter-shenanigans-sequel/2399)
**Author:** [@Millie\_K\_B](https://www.techhub.training/u/Millie_K_B)\ **Replies:** 7\ **Last updated:** [February 27, 2025, 6:26pm UTC](https://www.techhub.training/t/171-sql-shelter-shenanigans-sequel/2399 "2025-02-27T18:26:57Z")
BYU Student Author: @Millie\_K\_B Reviewers: @Sterling\_Lane, @jimmy\_han Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview This challenge i… --- ## [170|SQL – Booking Barney’s Bulk Books Buyers](https://www.techhub.training/t/170-sql-booking-barney-s-bulk-books-buyers/2396)
**Author:** [@James\_Gerstner](https://www.techhub.training/u/James_Gerstner)\ **Replies:** 15\ **Last updated:** [March 15, 2025, 5:12am UTC](https://www.techhub.training/t/170-sql-booking-barney-s-bulk-books-buyers/2396 "2025-03-15T05:12:48Z")
BYU Student Author: @James\_Gerstner Reviewers: @Jimmy\_Han, @Marta\_Ellsworth Estimated Time to Solve: 35 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview Barney’s B… --- ## [168|SQL – Trading Card Treasure Trove](https://www.techhub.training/t/168-sql-trading-card-treasure-trove/2393)
**Author:** [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\ **Replies:** 44\ **Last updated:** [March 16, 2025, 5:22am UTC](https://www.techhub.training/t/168-sql-trading-card-treasure-trove/2393 "2025-03-16T05:22:28Z")
BYU Student Author: @Sterling\_Lane Reviewers: @James\_Gerstner, @Andrew\_Wilson Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview You are … --- ## [167|SQL – Annual Order Reports](https://www.techhub.training/t/167-sql-annual-order-reports/2391)
**Author:** [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson)\ **Replies:** 1\ **Last updated:** [March 14, 2025, 4:23am UTC](https://www.techhub.training/t/167-sql-annual-order-reports/2391 "2025-03-14T04:23:43Z")
BYU Student Author: @Andrew\_Wilson Reviewers: @Benjamin\_Lau, @Millie\_K\_B Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview At Simple Scr… --- ## [166|SQL – The Guild of Gold](https://www.techhub.training/t/166-sql-the-guild-of-gold/2390)
**Author:** [@Marta\_Ellsworth](https://www.techhub.training/u/Marta_Ellsworth)\ **Replies:** 90\ **Last updated:** [March 13, 2025, 9:37pm UTC](https://www.techhub.training/t/166-sql-the-guild-of-gold/2390 "2025-03-13T21:37:22Z")
BYU Student Author: @Marta\_Ellsworth Reviewers: @Sterling\_Lane, @Andrew\_Wilson Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: SQL Need a program? Click here. Overview Welcome… --- ## [165|PYTHON – LePan’s Big Day](https://www.techhub.training/t/165-python-lepan-s-big-day/2264)
**Author:** [@Millie\_K\_B](https://www.techhub.training/u/Millie_K_B)\ **Replies:** 14\ **Last updated:** [January 28, 2025, 8:37pm UTC](https://www.techhub.training/t/165-python-lepan-s-big-day/2264 "2025-01-28T20:37:14Z")
BYU Student Author: @Millie\_K\_B Reviewers: @Trent\_Barlow, @Kyle\_nilsen Estimated Time to Solve: 20 Minutes This is an intro challenge that is part of the Python Learning Path. We provide the solution to this challeng… --- ## [164|EXCEL – Keyboard Shortcuts](https://www.techhub.training/t/164-excel-keyboard-shortcuts/2261)
**Author:** [@Benjamin\_Lau](https://www.techhub.training/u/Benjamin_Lau)\ **Replies:** 72\ **Last updated:** [November 11, 2025, 6:44pm UTC](https://www.techhub.training/t/164-excel-keyboard-shortcuts/2261 "2025-11-11T18:44:28Z")
BYU Student Author: @Benjamin\_Lau Reviewers: @Carter\_Lee @Dallin\_Gardner Estimated Time to Solve: 30 Minutes This is an intro challenge that is part of the Excel Learning Path. We provide the solution to this challen… --- ## [163|POWERBI – Peaks Cycles, Relationships and Paths](https://www.techhub.training/t/163-powerbi-peaks-cycles-relationships-and-paths/2260)
**Author:** [@Jacob\_Dutton](https://www.techhub.training/u/Jacob_Dutton)\ **Replies:** 25\ **Last updated:** [December 12, 2025, 4:33pm UTC](https://www.techhub.training/t/163-powerbi-peaks-cycles-relationships-and-paths/2260 "2025-12-12T16:33:06Z")
BYU Student Author: @Jacob\_Dutton Reviewers: @Jimmy\_Han, @James\_Gerstner Estimated Time to Solve: 10 Minutes This is an intro challenge that is part of the PowerBI Learning Path. We provide the solution to this chall… --- ## [162|POWERBI – Peaks Cycles, Creating Columns](https://www.techhub.training/t/162-powerbi-peaks-cycles-creating-columns/2259)
**Author:** [@James\_Gerstner](https://www.techhub.training/u/James_Gerstner)\ **Replies:** 11\ **Last updated:** [December 15, 2025, 11:32am UTC](https://www.techhub.training/t/162-powerbi-peaks-cycles-creating-columns/2259 "2025-12-15T11:32:54Z")
BYU Student Author: @James\_Gerstner Reviewers: @Jacob\_Dutton, @Jimmy\_Han Estimated Time to Solve: 25 Minutes This is an intro challenge that is part of the PowerBI Learning Path. We provide the solution to this chall… --- ## [161|PYTHON – Slice and Dice Megacorp, Inc](https://www.techhub.training/t/161-python-slice-and-dice-megacorp-inc/2255)
**Author:** [@Kyle\_Nilsen](https://www.techhub.training/u/Kyle_Nilsen)\ **Replies:** 1\ **Last updated:** [March 13, 2024, 4:26am UTC](https://www.techhub.training/t/161-python-slice-and-dice-megacorp-inc/2255 "2024-03-13T04:26:49Z")
BYU Student Author: @Kyle\_Nilsen Reviewers: @Millie\_K\_B, @Trent\_Barlow Estimated Time to Solve: 45 Minutes This is an intro challenge that is part of the Python Learning Path. We provide the solution to this challeng… --- ## [160|ALTERYX – The Formula to Success](https://www.techhub.training/t/160-alteryx-the-formula-to-success/2254)
**Author:** [@Marta\_Ellsworth](https://www.techhub.training/u/Marta_Ellsworth)\ **Replies:** 70\ **Last updated:** [April 18, 2025, 12:23am UTC](https://www.techhub.training/t/160-alteryx-the-formula-to-success/2254 "2025-04-18T00:23:58Z")
BYU Student Author: @Marta\_Ellsworth Reviewers: @Andrew\_Wilson, @Sterling\_Lane Estimated Time to Solve: 30 Minutes This is an intro challenge that is part of the Alteryx Learning Path. We provide the solution to this… --- ## [159|ALTERYX – Parsing Patterns with Regex](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253)
**Author:** [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\ **Replies:** 35\ **Last updated:** [April 17, 2025, 5:48pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253 "2025-04-17T17:48:57Z")
BYU Student Author: @Sterling\_Lane Reviewers: @Marta\_Ellsworth, @Andrew\_Wilson Estimated Time to Solve: 40 Minutes This is an intro challenge that is part of the Alteryx Learning Path. We provide the solution to this… --- ## [158|EXCEL – Text Manipulation](https://www.techhub.training/t/158-excel-text-manipulation/2252)
**Author:** [@Carter\_Lee](https://www.techhub.training/u/Carter_Lee)\ **Replies:** 143\ **Last updated:** [March 13, 2025, 5:53pm UTC](https://www.techhub.training/t/158-excel-text-manipulation/2252 "2025-03-13T17:53:41Z")
BYU Student Author: @Carter\_Lee Reviewers: @Benjamin\_Lau @Dallin\_Gardner Estimated Time to Solve: 10 Minutes This is an intro challenge that is part of the Excel Learning Path. We provide the solution to this challen… [Previous page](https://www.techhub.training/c/challenges/5.md?page=2) [Next page](https://www.techhub.training/c/challenges/5.md?page=4)