You can make use of the second custom SQL inquire to locate a good depend on just how many purchases and you can manage a left join towards Commands and you will Companies tables:
Problems when content columns are referenced
In case the customized SQL ask references backup articles, you may get mistakes when trying to make use of one of the articles on your own research in the Tableau. This may happen even if the ask holds true. Such, think about the after the query:
The latest inquire is valid, but the bien au_id field are ambiguous as in this instance it is present inside the “authors” table together with “titleauthor” table.