remove_duplicate_fruits.jl

function remove_duplicate_fruits(db_name::String, table_name::String)

    conn_db = connect_db(db_name)

    # Remove duplicate rows using a common table expression (cte)
    try
	DBInterface.execute(conn_db, 
		            "WITH cte AS (
	                    SELECT 
                                Name, 
                                Price, 
                                Origin,
			   ROW_NUMBER() OVER (
                           PARTITION BY 
                               Name
                           ORDER BY 
                               Name
				) row_num FROM $table_name ) 
			  DELETE FROM cte WHERE row_num > 1" )
		
    catch
	error("Unable to delete rows!")
    finally
	DBInterface.close!(conn_db)	
    end

    return nothing	

end