# MYSQL database missmatch

**URL:** <https://forum.codewithmosh.com/t/mysql-database-missmatch/21193>\
**Category:** SQL\
**Created:** [July 1, 2023, 11:25am UTC](https://forum.codewithmosh.com/t/mysql-database-missmatch/21193 "2023-07-01T11:25:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Denitsa](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@Denitsa](https://forum.codewithmosh.com/u/Denitsa)\
**Post date:** [July 1, 2023, 11:25am UTC](https://forum.codewithmosh.com/t/mysql-database-missmatch/21193/1 "2023-07-01T11:25:21Z")

</div>

Hi, I have noticed some mismatches between the results I am receiving and the solutions in the videos. Recently I have restored my database to it’s original state as advice by Mosh in order to continue my study. Currently I am at the ‘HAVING’ clause lesson where you have to find all the clients in state Virginia, in my database there is one and in the example there are two therefore non of my answers matches to the excesses solutions. **What I am doing wrong?** (I notice mismatch at the payment method name as well).

Thanks in advance,  
Deni

---

<div class="post-metadata">

**Author:** ![lucidlear](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/lucidlear/32/5477_2.png) [@lucidlear](https://forum.codewithmosh.com/u/lucidlear)\
**Post date:** [July 1, 2023, 12:14pm UTC](https://forum.codewithmosh.com/t/mysql-database-missmatch/21193/2 "2023-07-01T12:14:10Z")

</div>

> [@Denitsa](#):
>
> e results I am receiving and the solutions in the videos. Recently I have restored my database to it’s original state as advice b

Hi Denitsa,

Yes while 99% of the data is consistent, you may notice some slight inconsistency in the data returned from Mosh’s examples but don’t let it bother you as the underlying concepts are whats important not the actual results you get back. If you needed more info on these data inconsistencies please check these threads below.

[Having clause](https://forum.codewithmosh.com/t/having-clause-output-mismatches/3924)

[In accurate data](https://forum.codewithmosh.com/t/in-accurate-data/2170/3)

---

<div class="post-metadata">

**Author:** ![Denitsa](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@Denitsa](https://forum.codewithmosh.com/u/Denitsa)\
**Post date:** [July 1, 2023, 5:54pm UTC](https://forum.codewithmosh.com/t/mysql-database-missmatch/21193/3 "2023-07-01T17:54:45Z")

</div>

Thank you! I though that I may missing something.