This query fetches the detailed information related to those assets which are added newly for a particular period.  SELECT  FAL.segment...