title: How to find a missing element in a sql table
body: <p>I have a SQL database with some data that are added daily by a third person, each person has to add 10 lines of data to one of my tables trough a form , but sometimes someone forget to add one of those lines, each line represent a different result, what i wanna do is display what line wasnt inserted in a specific day and shift, here is an example of the table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>data_id</th>
  <th>user</th>
  <th>date</th>
  <th>shift</th>
  <th>machine</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>3227</td>
  <td>100</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG01</td>
  </tr>
  <tr>
  <td>3228</td>
  <td>103</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG02</td>
  </tr>
  <tr>
  <td>3229</td>
  <td>103</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG03</td>
  </tr>
  <tr>
  <td>3230</td>
  <td>100</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG04</td>
  </tr>
  <tr>
  <td>3231</td>
  <td>105</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG05</td>
  </tr>
  <tr>
  <td>3232</td>
  <td>100</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG06</td>
  </tr>
  <tr>
  <td>3233</td>
  <td>107</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG07</td>
  </tr>
  <tr>
  <td>3234</td>
  <td>100</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG08</td>
  </tr>
  <tr>
  <td>3235</td>
  <td>108</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG09</td>
  </tr>
  <tr>
  <td>3236</td>
  <td>100</td>
  <td>28/11/2021</td>
  <td>1</td>
  <td>TG010</td>
  </tr>
  <tr>
  <td>3237</td>
  <td>101</td>
  <td>28/11/2021</td>
  <td>2</td>
  <td>TG01</td>
  </tr>
  <tr>
  <td>3238</td>
  <td>101</td>
  <td>28/11/2021</td>
  <td>2</td>
  <td>TG04</td>
  </tr>
  <tr>
  <td>3239</td>
  <td>101</td>
  <td>28/11/2021</td>
  <td>2</td>
  <td>TG05</td>
  </tr>
  <tr>
  <td>3240</td>
  <td>109</td>
  <td>28/11/2021</td>
  <td>2</td>
  <td>TG06</td>
  </tr>
  <tr>
  <td>3241</td>
  <td>106</td>
  <td>28/11/2021</td>
  <td>2</td>
  <td>TG07</td>
  </tr>
  <tr>
  <td>3242</td>
  <td>101</td>
  <td>28/11/2021</td>
  <td>2</td>
  <td>TG08</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>i must have TG01, TG02, TG03 ....TG10 for every shift, how can i display in a case like in shift 2 which ones are missing?
  i would like to use an sql query to display it in powerbi to not have to manually check it every day</p>