# SQL **URL:** https://forum.codewithmosh.com/c/sql/10.md [Latest](https://forum.codewithmosh.com/latest.md) · [Categories](https://forum.codewithmosh.com/categories.md) --- ## [About the SQL category](https://forum.codewithmosh.com/t/about-the-sql-category/21)
**Author:** [@Mosh](https://forum.codewithmosh.com/u/Mosh)\ **Replies:** 0\ **Last updated:** [October 22, 2020, 10:27pm UTC](https://forum.codewithmosh.com/t/about-the-sql-category/21 "2020-10-22T22:27:48Z")
--- ## [Help me I don't have all the data - data is missing from zip file](https://forum.codewithmosh.com/t/help-me-i-dont-have-all-the-data-data-is-missing-from-zip-file/72794)
**Author:** [@TManda](https://forum.codewithmosh.com/u/TManda)\ **Replies:** 1\ **Last updated:** [November 1, 2026, 7:22pm UTC](https://forum.codewithmosh.com/t/help-me-i-dont-have-all-the-data-data-is-missing-from-zip-file/72794 "2026-11-01T19:22:12Z")
I am following along with the course and it does not have all the tables for sql\_store - like customer name - I downloaded the zip file and it is missing data - please help. --- ## [NO CTE Module in the Complete SQL Mastery course](https://forum.codewithmosh.com/t/no-cte-module-in-the-complete-sql-mastery-course/72804)
**Author:** [@Iamharsh](https://forum.codewithmosh.com/u/Iamharsh)\ **Replies:** 1\ **Last updated:** [October 29, 2026, 4:29pm UTC](https://forum.codewithmosh.com/t/no-cte-module-in-the-complete-sql-mastery-course/72804 "2026-10-29T16:29:51Z")
I purchsed the course Complete SQL Mastery as i am preparing for career pivot from Mechanical enginering to DATA Analytics/Engineering and after following course for the while i came to know that there’s no module for th… --- ## [Complete SQL Mastery - Creating Views](https://forum.codewithmosh.com/t/complete-sql-mastery-creating-views/73115)
**Author:** [@rjjski](https://forum.codewithmosh.com/u/rjjski)\ **Replies:** 4\ **Last updated:** [October 29, 2026, 12:01pm UTC](https://forum.codewithmosh.com/t/complete-sql-mastery-creating-views/73115 "2026-10-29T12:01:49Z")
Can someone explain to me why when I’m Creating a View, once I enter the sum of invoice minus the payment history I can’t see the actual invoice or payment totals. The Code works as described by Mosh, I just don’t get th… --- ## [SQL database reporting with Crystal Reports](https://forum.codewithmosh.com/t/sql-database-reporting-with-crystal-reports/72122)
**Author:** [@rhwette](https://forum.codewithmosh.com/u/rhwette)\ **Replies:** 1\ **Last updated:** [January 21, 2026, 12:58am UTC](https://forum.codewithmosh.com/t/sql-database-reporting-with-crystal-reports/72122 "2026-01-21T00:58:53Z")
Has anyone used Crystal Reports to interface with SQL databases? Is there another, better tool to create reports? thanks Rich W --- ## [MySQL says that I need to get the new version](https://forum.codewithmosh.com/t/mysql-says-that-i-need-to-get-the-new-version/72150)
**Author:** [@SadiePup](https://forum.codewithmosh.com/u/SadiePup)\ **Replies:** 1\ **Last updated:** [January 21, 2026, 12:49am UTC](https://forum.codewithmosh.com/t/mysql-says-that-i-need-to-get-the-new-version/72150 "2026-01-21T00:49:48Z")
I’m retaking SQL. Says some things won’t work properly. Should I leave it alone or update? do I need to remove the old one first? Thank you !! --- ## [Data Output Not Matching](https://forum.codewithmosh.com/t/data-output-not-matching/71969)
**Author:** [@Mahid](https://forum.codewithmosh.com/u/Mahid)\ **Replies:** 3\ **Last updated:** [December 12, 2025, 11:01am UTC](https://forum.codewithmosh.com/t/data-output-not-matching/71969 "2025-12-12T11:01:04Z")
On Summarizing Data Section After Executing to restore the Whole Database and restoring it , My Results are not matching , could kindly anyone solve it , or tell me my mistake, this is on section summarizing data and usi… --- ## [Video not playing](https://forum.codewithmosh.com/t/video-not-playing/71956)
**Author:** [@Sameer](https://forum.codewithmosh.com/u/Sameer)\ **Replies:** 0\ **Last updated:** [December 8, 2025, 2:51pm UTC](https://forum.codewithmosh.com/t/video-not-playing/71956 "2025-12-08T14:51:12Z")
Hi Team, I am not able to play video for SQL. Here is the error message. Please check and let me know if it is working. Thanks! Sameer --- ## [MySQL MS SQL SMS software](https://forum.codewithmosh.com/t/mysql-ms-sql-sms-software/6035)
**Author:** [@Safwan](https://forum.codewithmosh.com/u/Safwan)\ **Replies:** 3\ **Last updated:** [October 19, 2025, 7:15pm UTC](https://forum.codewithmosh.com/t/mysql-ms-sql-sms-software/6035 "2025-10-19T19:15:57Z")
Hi, Mosh uses MySQL but I use MS SQL Server Management Studio and I’m getting some errors, does MySQL and MS SQL use different coding like some parts of the coding is written a bit differently because I think I might be… --- ## [Help understanding these two outputs from correlated sub-query exercise](https://forum.codewithmosh.com/t/help-understanding-these-two-outputs-from-correlated-sub-query-exercise/71708)
**Author:** [@vesred](https://forum.codewithmosh.com/u/vesred)\ **Replies:** 1\ **Last updated:** [October 19, 2025, 10:21am UTC](https://forum.codewithmosh.com/t/help-understanding-these-two-outputs-from-correlated-sub-query-exercise/71708 "2025-10-19T10:21:25Z")
Hello, I need some help understanding the difference between these two queries. The first query i’m not using a correlated sub-query but still a sub-query non-the-less. I believe I am asking list the employees who ha… --- ## [Different set of databases](https://forum.codewithmosh.com/t/different-set-of-databases/71559)
**Author:** [@JuliaInj](https://forum.codewithmosh.com/u/JuliaInj)\ **Replies:** 4\ **Last updated:** [October 19, 2025, 9:18am UTC](https://forum.codewithmosh.com/t/different-set-of-databases/71559 "2025-10-19T09:18:31Z")
Hello, I’m currently on learing the HAVING clauses, however the results I got seemed different from the solution on the video clip, I have double checked and restored the DB multiple times, upon looking into the original… --- ## [Issues faced with downloading SQL & Workbench](https://forum.codewithmosh.com/t/issues-faced-with-downloading-sql-workbench/71629)
**Author:** [@Andrea1993](https://forum.codewithmosh.com/u/Andrea1993)\ **Replies:** 0\ **Last updated:** [October 4, 2025, 4:15am UTC](https://forum.codewithmosh.com/t/issues-faced-with-downloading-sql-workbench/71629 "2025-10-04T04:15:18Z")
I am finding it difficult to download SQL and was hoping that someone can help with this. The workbench shows the above and I am not able to access it. I am not sure if this is the correct way or if I am doing someth… --- ## [MySQL connection warning](https://forum.codewithmosh.com/t/mysql-connection-warning/71622)
**Author:** [@Mahri](https://forum.codewithmosh.com/u/Mahri)\ **Replies:** 0\ **Last updated:** [October 1, 2025, 11:18pm UTC](https://forum.codewithmosh.com/t/mysql-connection-warning/71622 "2025-10-01T23:18:22Z")
Hi, MySQLWorkbench is saying Local Instance-Warning-Not supported. tried everything, but failed. Has anyone had this kind of problem and do you know what to do? --- ## [Aggregates not functioning](https://forum.codewithmosh.com/t/aggregates-not-functioning/10898)
**Author:** [@CrystalG](https://forum.codewithmosh.com/u/CrystalG)\ **Replies:** 11\ **Last updated:** [September 20, 2025, 2:31pm UTC](https://forum.codewithmosh.com/t/aggregates-not-functioning/10898 "2025-09-20T14:31:23Z")
I on the aggregates lesson. None of my Aggregate functions are working. None of them turn blue. I checked to make sure there are no spaces, i.e., MAX(), AVE(). They are still grey with no function. I am working MySQL fro… --- ## [Forget my password or may username](https://forum.codewithmosh.com/t/forget-my-password-or-may-username/20857)
**Author:** [@Huajianchen](https://forum.codewithmosh.com/u/Huajianchen)\ **Replies:** 7\ **Last updated:** [September 19, 2025, 5:40pm UTC](https://forum.codewithmosh.com/t/forget-my-password-or-may-username/20857 "2025-09-19T17:40:33Z")
Hello, Mosh. I’m having trouble accessing my account because I forgot my password. I’ve attempted to reset it by clicking the “reset my password” button, but I haven’t received any emails. I’ve also tried connecting the … --- ## [Where is the complete cheat sheet for MYSQL course?!](https://forum.codewithmosh.com/t/where-is-the-complete-cheat-sheet-for-mysql-course/71539)
**Author:** [@moustafahesham](https://forum.codewithmosh.com/u/moustafahesham)\ **Replies:** 2\ **Last updated:** [September 19, 2025, 5:37pm UTC](https://forum.codewithmosh.com/t/where-is-the-complete-cheat-sheet-for-mysql-course/71539 "2025-09-19T17:37:58Z")
I downloaded the cheat sheet of MYSQL and i paid the full course, and I can not find the full cheat sheet?? --- ## [Issue in qownloading SQL](https://forum.codewithmosh.com/t/issue-in-qownloading-sql/71188)
**Author:** [@hamizan](https://forum.codewithmosh.com/u/hamizan)\ **Replies:** 5\ **Last updated:** [August 8, 2025, 3:02am UTC](https://forum.codewithmosh.com/t/issue-in-qownloading-sql/71188 "2025-08-08T03:02:50Z")
Different setup type than in the course. Which is don’t have ‘Developer default’. What I need to do? Please consult me . --- ## [PLEASE HELP Summarizing Data-Aggregate Functions Exercise giving me different results](https://forum.codewithmosh.com/t/please-help-summarizing-data-aggregate-functions-exercise-giving-me-different-results/30124)
**Author:** [@raamz909](https://forum.codewithmosh.com/u/raamz909)\ **Replies:** 2\ **Last updated:** [April 14, 2025, 3:52pm UTC](https://forum.codewithmosh.com/t/please-help-summarizing-data-aggregate-functions-exercise-giving-me-different-results/30124 "2025-04-14T15:52:29Z")
I’m getting different results on the summarizing data/aggregate functions exercise and my code is the same as mosh’s, here is my code: @Mosh :sob: SELECT 'First half of 2019' AS range\_date, SUM(invoice\_total) AS … --- ## [Database has different records on customers table](https://forum.codewithmosh.com/t/database-has-different-records-on-customers-table/71175)
**Author:** [@joshuacos2777](https://forum.codewithmosh.com/u/joshuacos2777)\ **Replies:** 0\ **Last updated:** [April 14, 2025, 3:32pm UTC](https://forum.codewithmosh.com/t/database-has-different-records-on-customers-table/71175 "2025-04-14T15:32:26Z")
I am sturdying “HAving” clause ,so when i do the exercise ,customers records are diffferent than what i have.I already run the query to create new databases. When i query for the state ‘VA’,it pulls out only one row … --- ## [No google translate support](https://forum.codewithmosh.com/t/no-google-translate-support/16909)
**Author:** [@Nikita](https://forum.codewithmosh.com/u/Nikita)\ **Replies:** 2\ **Last updated:** [January 28, 2025, 3:14pm UTC](https://forum.codewithmosh.com/t/no-google-translate-support/16909 "2025-01-28T15:14:12Z")
Hello! I watch the course with active subtitles and with google translator so that the subtitles are translated into my language. Tell me, could you bring back the old form of subtitles, please? --- ## [Importing Mosh's SQL Course Materials files using MYSQL Workbench](https://forum.codewithmosh.com/t/importing-moshs-sql-course-materials-files-using-mysql-workbench/31008)
**Author:** [@msw1doc](https://forum.codewithmosh.com/u/msw1doc)\ **Replies:** 5\ **Last updated:** [January 5, 2025, 5:51am UTC](https://forum.codewithmosh.com/t/importing-moshs-sql-course-materials-files-using-mysql-workbench/31008 "2025-01-05T05:51:15Z")
Following the steps to import .sql file using MySQL Workbench suggested on Import an SQL file in MySQL (Using CMD or Powershell) - QA With Experts I get the following ERROR: ‘utf-8’ codec can’t decode byte 0xe4 in po… --- ## [MySQL vs SQL. Differences and benefits](https://forum.codewithmosh.com/t/mysql-vs-sql-differences-and-benefits/1817)
**Author:** [@slimally22](https://forum.codewithmosh.com/u/slimally22)\ **Replies:** 3\ **Last updated:** [December 29, 2024, 2:09pm UTC](https://forum.codewithmosh.com/t/mysql-vs-sql-differences-and-benefits/1817 "2024-12-29T14:09:00Z")
Greetings everyone. How superior is SQL server compared to MySQL in terms of querying? Is there a huge difference? How applicable and relevant is MySQL in the world in terms of Data Science, BI, Machine Learning etc. R… --- ## [How hard to learn SQL from scratch?](https://forum.codewithmosh.com/t/how-hard-to-learn-sql-from-scratch/15981)
**Author:** [@VillSkill](https://forum.codewithmosh.com/u/VillSkill)\ **Replies:** 2\ **Last updated:** [October 21, 2022, 1:43pm UTC](https://forum.codewithmosh.com/t/how-hard-to-learn-sql-from-scratch/15981 "2022-10-21T13:43:11Z")
Hi folks, I have zero programming experience, but I can do some basic things in HTML. I work in digital marketing so sometimes I need to analyse data. I’ve seen a job ad that asks the marketer to use SQL. So I want to t… --- ## [In accurate data](https://forum.codewithmosh.com/t/in-accurate-data/2170)
**Author:** [@pfabbi](https://forum.codewithmosh.com/u/pfabbi)\ **Replies:** 13\ **Last updated:** [November 29, 2024, 2:55am UTC](https://forum.codewithmosh.com/t/in-accurate-data/2170 "2024-11-29T02:55:50Z")
I’m currently on the Aggrevate Functions Exercise and my results are not same under my “total\_payments” and “what\_we\_expect” column. I restored the databases as instructed yet not all of my numbers the same. Did Mosh rec… --- ## [MySQL installation error on Mac](https://forum.codewithmosh.com/t/mysql-installation-error-on-mac/26882)
**Author:** [@ayda.mirsalehi](https://forum.codewithmosh.com/u/ayda.mirsalehi)\ **Replies:** 2\ **Last updated:** [November 22, 2024, 9:43am UTC](https://forum.codewithmosh.com/t/mysql-installation-error-on-mac/26882 "2024-11-22T09:43:11Z")
While trying to install MySQL on my Mac I get the error “MySQL 8.4.0-community can’t be installed on this computer”. MacOS is Ventura 13.6.1. any suggestion would be appreciated. --- ## [Tips on landing a job as a data analyst?](https://forum.codewithmosh.com/t/tips-on-landing-a-job-as-a-data-analyst/3096)
**Author:** [@HubbsBuns](https://forum.codewithmosh.com/u/HubbsBuns)\ **Replies:** 5\ **Last updated:** [August 22, 2023, 4:45pm UTC](https://forum.codewithmosh.com/t/tips-on-landing-a-job-as-a-data-analyst/3096 "2023-08-22T16:45:58Z")
Hi, I am about halfway through the sql mastery course from Mosh and upon looking reddit, it seems that the first 50% of the sql course is good enough to land an entry level job. For an understanding of my current knowle… --- ## [SQL Mastery Cheat Sheet](https://forum.codewithmosh.com/t/sql-mastery-cheat-sheet/29303)
**Author:** [@AlieuB2050](https://forum.codewithmosh.com/u/AlieuB2050)\ **Replies:** 2\ **Last updated:** [October 24, 2024, 9:14pm UTC](https://forum.codewithmosh.com/t/sql-mastery-cheat-sheet/29303 "2024-10-24T21:14:46Z")
I recently purchased the SQL mastery course about hours ago but have not yet received the course materials and cheat sheet. Can you please send it to my email: alieub2050@gmail.com Thank you, --- ## [SQL Mastery Course Material Zip Files](https://forum.codewithmosh.com/t/sql-mastery-course-material-zip-files/29376)
**Author:** [@AlieuB2050](https://forum.codewithmosh.com/u/AlieuB2050)\ **Replies:** 0\ **Last updated:** [October 21, 2024, 12:27pm UTC](https://forum.codewithmosh.com/t/sql-mastery-course-material-zip-files/29376 "2024-10-21T12:27:51Z")
Hello, I purchased the SQL course, but I have, yet to receive the course material zip file. Can you please send me the course files, please send it to me at: alieub2050@gmail.com --- ## [SQL Course Material zip file](https://forum.codewithmosh.com/t/sql-course-material-zip-file/23346)
**Author:** [@Nyi](https://forum.codewithmosh.com/u/Nyi)\ **Replies:** 7\ **Last updated:** [October 12, 2024, 1:11pm UTC](https://forum.codewithmosh.com/t/sql-course-material-zip-file/23346 "2024-10-12T13:11:42Z")
can anyone send me zip file of ‘sql course material.zip’ as the link on YouTube is giving me an error ’ This site can’t provide a secure connection. codewithmosh-assets.netlify.app sent an invalid response.’ thanks in ad… --- ## [Not able to download data base zip file](https://forum.codewithmosh.com/t/not-able-to-download-data-base-zip-file/7080)
**Author:** [@Muhammad\_Ali](https://forum.codewithmosh.com/u/Muhammad_Ali)\ **Replies:** 6\ **Last updated:** [October 12, 2024, 1:01pm UTC](https://forum.codewithmosh.com/t/not-able-to-download-data-base-zip-file/7080 "2024-10-12T13:01:36Z")
hi kindly help me I am not able to find that zip folder for databases in video description about which sir is talking about. Kindly guide me or can any one send me. Thanks in advance . [Next page](https://forum.codewithmosh.com/c/sql/10.md?page=1)