Databricks Community

@RohitKulkarni here is the link with all the details https://www.databricks.com/learn/certification/data-engineer-professional

@Kurtis_R do you want to display the value of 45 or formula of how 45 is achieved.?

You need to test in Python and scala based on the complexity one of it outperforms the other. In few cases Python was faster where as in other Scala. It is all about the efficiency of the code

SELECT album.ArtistId ,DISTINCT album.ArtistId AS my_alias FROM album ORDER BY album.ArtistIdCan you try this

A simple wayselect FIELD_TEXT from TABLE 1 where FIELD_TEXT like 'italia' OR FIELD_TEXT like 'mex' OR FIELD_TEXT like 'coke'